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

query based on check boxes

P: n/a
I searched google groups for an answer but found none that I could
completely understand. I have a table. It contains fields such as
'client,date,hours,project,employee.' I have a form that lists all the
clients on one tab. On another tab in the same form all the employees
are listed. Each have a check box next to them (both client and
employee). I want to run a query based on what is checked on both
tabs. Thanks in advance for any and all help.

Aug 4 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a

so**************@gmail.com wrote:
I searched google groups for an answer but found none that I could
completely understand. I have a table. It contains fields such as
'client,date,hours,project,employee.' I have a form that lists all the
clients on one tab. On another tab in the same form all the employees
are listed. Each have a check box next to them (both client and
employee). I want to run a query based on what is checked on both
tabs. Thanks in advance for any and all help.
If you can only choose one of each (person, project, etc), you should
use a combobox instead of a checkbox.

Aug 5 '06 #2

P: n/a
No you can choose more than one person and project. A combo box
wouldn't work in this instance. I did look into a multi select box but
I'm not really sure how to implement it.
pi********@hotmail.com wrote:
so**************@gmail.com wrote:
I searched google groups for an answer but found none that I could
completely understand. I have a table. It contains fields such as
'client,date,hours,project,employee.' I have a form that lists all the
clients on one tab. On another tab in the same form all the employees
are listed. Each have a check box next to them (both client and
employee). I want to run a query based on what is checked on both
tabs. Thanks in advance for any and all help.

If you can only choose one of each (person, project, etc), you should
use a combobox instead of a checkbox.
Aug 6 '06 #3

P: n/a
I found my answer here. I thought it might help someone else.

http://groups.google.com/group/comp....b72fb6d93d0c89
gambit32 wrote:
No you can choose more than one person and project. A combo box
wouldn't work in this instance. I did look into a multi select box but
I'm not really sure how to implement it.
pi********@hotmail.com wrote:
so**************@gmail.com wrote:
I searched google groups for an answer but found none that I could
completely understand. I have a table. It contains fields such as
'client,date,hours,project,employee.' I have a form that lists all the
clients on one tab. On another tab in the same form all the employees
are listed. Each have a check box next to them (both client and
employee). I want to run a query based on what is checked on both
tabs. Thanks in advance for any and all help.
If you can only choose one of each (person, project, etc), you should
use a combobox instead of a checkbox.
Aug 10 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.