klallen810
Registered User.
- Local time
- Yesterday, 22:44
- Joined
- Jul 18, 2012
- Messages
- 15
Hello,
I am trying to filter a form that is based on a query by multiple values contained in checkboxes on another form. I don't have enough room to put all of the checkboxes on the first form so I created a second one. The first form is a list of items that are due today, there are multiple items per city, and i would like to filter the form by city, 1 city or multiple cities. The second form has a list of all of the cities with a checkbox next to them, which is based off a table called tUSCities. I would like to open that form, click the "Filter" button, and then have the original form filter by the cities chosen. The following SQL is how I would like the form filtered:
SELECT * FROM q_DueToday INNER JOIN tUSCities ON q_DueToday.City = tUSCities.City WHERE (((tUSCities.[SELECT])=True) AND ((tUSCities.[SELECT])=True))
This query pulls up the correct data in datasheet view, but I would like to apply this to the form which is based off of the query q_DueToday
This is a shared database so different people should be able to see the whole q_DueToday form, or be able to filter it any way they would like without it disrupting other peoples views. I don't know if I explained this well, but if you have any questions please let me know. Thanks!
I am trying to filter a form that is based on a query by multiple values contained in checkboxes on another form. I don't have enough room to put all of the checkboxes on the first form so I created a second one. The first form is a list of items that are due today, there are multiple items per city, and i would like to filter the form by city, 1 city or multiple cities. The second form has a list of all of the cities with a checkbox next to them, which is based off a table called tUSCities. I would like to open that form, click the "Filter" button, and then have the original form filter by the cities chosen. The following SQL is how I would like the form filtered:
SELECT * FROM q_DueToday INNER JOIN tUSCities ON q_DueToday.City = tUSCities.City WHERE (((tUSCities.[SELECT])=True) AND ((tUSCities.[SELECT])=True))
This query pulls up the correct data in datasheet view, but I would like to apply this to the form which is based off of the query q_DueToday
This is a shared database so different people should be able to see the whole q_DueToday form, or be able to filter it any way they would like without it disrupting other peoples views. I don't know if I explained this well, but if you have any questions please let me know. Thanks!
