Creating a search form with checkboxes

[laurapizzolo]

Hi,

This sounds painfully easy and I'm sure everyone will skip it, but for
some reason I have a little problem that's so evidently solved by
everyone (but me) that i can't find any decent answer or help in the
reference books etc...

I'm preparing a search form for a data base i'm miraculously supposed
to pull together with no training or skills (self-taught suddenly
sounds ambitious, cause I don't remember learning much even though I
was all by myself). What I need to do is search a wide variety of
information (word documents and pdf files) that is already separated
into different folders. So, basically, I need to search a table that
lists all the different folders.

I have 4 critieria to do this:
Country
Consultant
Name
Action

knowing that Action is really a header for 5 different possibilities:
garbage, transport, energy, nature and other.

My masterplan would have been to create a form with drop boxes for the
first 3 (country, consultatn and name) and then an object of 5 check
boxes for the 4th criteria.

Which I did

But, somehow, i can only check one at a time....???? was i supposed to
do something special? (other than be sure that the field is set for
numerical info)

also, how do i enter information in the database table?


thanks abundantly,

lkaura

 

[microb0x]

How did you create the checkboxes on your form? Were they created
using an Option Group? You would need to create each checkbox
separately I believe. Creating them with an option group is creating a
scenerio that is like: (check1 or check2 or check3, etc.) which it
sounds like this is NOT what you want. You want to be able to select
multiple, so just use the Checkbox option from the toolbox instead of
option group.

More info is needed to help with populating your table(s). How would
you like to accomplish this? Through entry on a form? With VBA code?
With a macro? Manually typing directly into the table?