access vba

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

resolvedResolved · Low Priority · Version 2010

Edited on Thu 5 Apr 2012, 11:40

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

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

 

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

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


Server loaded in 0.08 secs.