Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Having One Form Instead of Multiple Forms 1

Status
Not open for further replies.

lewis33

Technical User
May 21, 2001
64
US
Hello, I was looking for a bit of direction on a project.
I had a table that has data and it is grouped by state counties.
I made a datasheet form from this. I will then put the database on a network so that people can audit the data through the form.

Since there are 88 counties in the data and the staff would like to look at only one county's worth of data at a time, I'd rather not make up 88 different tables or 88 different forms.

Can I set up a switchboard that goes to an initial form with a dropdown list of counties and then use the results from the user to do something like see the datasheet form with only the chosen county? Thank you for any input.
 
You only need one table. Build a form with a combo box so you can choose which county (or counties) from the list. Then design a parameter query to read the criteria from the information on the combo box. A detailed tutorial on how to do this is available at
 
Thank you ShannonSkipper. That's most helpful.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top