All option for pull down menu in form

V

Vernon

In the form I created that allows users to query for
records, I use two date fields (setting a constraint on
the timeframe for the records retreived) and two pull down
menus that specify the "Jurisdiction" and "Zone" of the
data received.

Both the "Jurisdiction" and "Zone" fields are pull down
menus referencing text data from their respective tables
("tbl_Jurisdiction" and "tbl_Zone"). Each table has
approximately 8 choices (for example, Zone has options
like "Southwest Area" "Northwest Area" "Central Area"
etc...). Neither table has an "All" option that would
allow users to get data for all zones and/or all
jurisdictions for a given range of dates.

What is the simplest way to do this (I am no access
wizard)?

I appreciate your time and help,
Kendra
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down box -- select all option 1
Subform w/table records as option choices (NOT OPTION GROUP) 7
Query from a pull down menu... 3
linking normalized tables in forms 2
Lookup help for pull-downs 7
How do I change the font size of a pull down menu in MS Excel 1
Not all data in AutoFilter pull down 2
Pull down for Option Group 2

Top