By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,374 Members | 2,993 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,374 IT Pros & Developers. It's quick & easy.

Filter query from Checklist box

P: 34
what code to make checklist on that form as a filter for the query?

in criteria date i write Between [Forms]![Filter Form]![tb_DateBegin] And [Forms]![Filter Form]![tb_DateEnd]

and its work!!!

but i don't know how to write criteria using checklist on the form.

All image in attachment
Attached Images
File Type: jpg table student.jpg (17.7 KB, 168 views)
File Type: jpg table score.jpg (30.4 KB, 137 views)
File Type: jpg form.jpg (14.0 KB, 162 views)
File Type: jpg query.jpg (22.9 KB, 140 views)
Attached Files
File Type: zip (54.7 KB, 78 views)
Sep 19 '12 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 100+
P: 2,321
Using a checklist in the way you suggest is usually not recommended. You would need alot of work to expand the code to include more cities. However, if you are quite sure that you will not need to operate in more cities then those mentioned, then we/you can proceed with the intended approach.

Your approach gets especially complicated since you want to convert a checkbox check to a comparision against a text field.
Sep 19 '12 #2

P: 34
that's the point, because if we use the text field, the problem was solved, or do you have any suggestion how to filter some data instead write manually on query?
Sep 19 '12 #3

Expert Mod 100+
P: 2,321
I would use a table of cities tbl_Cities with 2 fields, a primary KEY of type autonumber and a field with the city name. (One could add stuff such as postal code, or state but that is irrelevant for the question at hand)

Storing the city name as plain text in each individual record breaks the rules of database normalisation.
Sep 19 '12 #4

Post your reply

Sign in to post your reply or Sign up for a free account.