Qry from Form with checkboxes

  • Thread starter Thread starter Matthew G
  • Start date Start date
M

Matthew G

I'm trying to query a set of data and I'd like to use a
form. I have 16 check boxes... three different shifts on
5 weekdays and an "any" box.

I'd like the user to be able to select a check box and
have the people who are available show up in a query.

Can anyone help?
 
Dear Matthew:

I recommend you put the 16 values in a combo box and have the user
choose one. These values are mutually exclusive, aren't they?

Just how well this would work depends on how the "shift" is
represented in the database. I'm guessing it may be that you have one
of 15 values in it, for 5 days by 3 shifts.

You could put these 15 values in a table in just the way you want to
display them, along with the 16th value for "any". In another column
you could put the values you want stored. For "any" this could
contain an asterisk. Put this second column, the actual "search
pattern" for each one, into the combo box as well, but hide it. Your
query could then reference this hidden column with LIKE and it will
function the way I think you want it to function.

Your post is short on information to be able to tell you anything more
specific.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Back
Top