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) 8
linking normalized tables in forms 2
how to filter information in a data access page 0
create pull down menu to select multiple options 6
Pulling data from other wb based on data to populate dropdown list 0
Query from a pull down menu... 3
Pull Down Menu referencing to another page 1

Top