Hi
I have created a menu for my db. On this menu there is a button where users
click on to search the db by county. Then they have to enter the county, but
instead I would like to know how to create a drop down list for the user (so
they can just select the county).
In my customer table I have created a drop down list for county, so the user
does not have to enter it.
Do I have to change the criteria in my county query? At the moment it states
-
Like [Enter County] & "*"
Thank you very much,
Louisa Holt
Roger Carlson - 22 Mar 2007 16:35 GMT
On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "ComboChoosesRecord.mdb" which illustrates how to do this.

Signature
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
> Hi
>
[quoted text clipped - 15 lines]
> Thank you very much,
> Louisa Holt