A last question: I use Access 2007. When I open the Combobox wizard only shows two alternatives. The last alternative "Find a record on my form based on the value I selected in my Combobow" is not there. Does that has to do with the 2007 version? How do I find this alternative?
Reply from Richard Rost:
Yes... this is actually something I'm addresses RIGHT NOW in my new Access Search Seminar. In order for that 3rd option to show up, your form has to be based on a TABLE or QUERY - not an SQL statement, which is what the new Access "Quick Form Builder" uses. Open up your form's properties and change the SQL statement in the Control Source to an actual TABLE name. Then remake your combo box.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Microsoft Access 203.
