Collecting parameter for query using check box

[sadat]

Hi,

Good day to you. I have got a problem. I have a table named main table which
has three columns-Share Date, Company Name and Share Price. I made a form
which has two text box to collect date range parameter and some check box
which contains different company name. So far the text boxes can collect date
ranges successfully. But my problem is I cant use the check boxes to collect
parameters for company name. Note that I want to select multiple check boxes.
Can any one help me with this?

Thanks and regards,
Sadat Mainuddin

 

[Steve Schapel]

Sadat,

I assume you have a table which is a "master list" of all Companies? If
so, add another field to this table, being a Yes/No data type. Then, on
your form, add a subform based on this Companies table. So you see, you
will then select the companies for your query criteria by ticking the
checkboxes in the subform for the required companies.

Ok, then add this table also to your query, presumably joined on the
Company Name field. And then you only need to enter the Criteria of -1
in the query for the Yes/no selector field.

 

[sadat]

Thanks Steve. As always your answers are brilliant and easy to understand.

Regards,
Sadat