Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Access VBA combobox add first item to .RowSourceType = "Table/Qu

Access VBA combobox add first item to .RowSourceType = "Table/Qu

ResolvedVersion 2010

Wed 4 Apr 2012, 11:27 Edited on Thu 5 Apr 2012, 11:40 Delegate Phillip said...

Phillip has attended:
Access Introduction course
Access Intermediate course
Access VBA course
Access Advanced course

Access VBA combobox add first item to .RowSourceType = "Table/Qu

Hi

How can I append an item to a combo box driven by a SQL query?

I have a combo box of .RowSourceType = "Table/Query" but want to add something like a "Please select" as the first item; how can I do that?

Thanks

Phil

Thu 12 Apr 2012, 13:10 Trainer Anthony said...

RE: Access VBA combobox add first item to .RowSourceType = "Tabl

Hi Phillip, thanks for your query. Have a look at the links below for a solution to this:

http://www.vbaexpress.com/forum/archive/index.php/t-24947.html

http://www.functionx.com/vbaccess/controls/combobox.htm

Hope this helps,

Anthony

Thu 19 Apr 2012: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Access tip:

Hiding Multiple Table columns

If you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide.

On the Format menu, click Unhide Columns.
In the Unhide Columns dialog box, clear the check box next to the name of each column you want to hide.
Click Close.

This method makes having to use the Hide Columns command repeatedly unnecessary

View all Access hints and tips

Access VBA combobox add first item to .RowSourceType = "Table/Qu

Access VBA combobox add first item to .RowSourceType = "Table/Qu

RE: Access VBA combobox add first item to .RowSourceType = "Tabl

Access articles

Access tip:

Hiding Multiple Table columns