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

Resolved · Low Priority · Version 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.8 % recommend us
	More live stats...

Training information:

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

Access tip:

Relationship maps

It is important to create proper relationships between tables. You can use Access to help check your designs and evaluate them by printing them in graphical format to help with design purposes

Click on the Tools menu, click Relationships.
On the File menu, click Print Relationships. View or print as required

View all Access hints and tips