Collecting parameter for query using check box

  • Thread starter Thread starter sadat
  • Start date Start date
S

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
 
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.
 
Back
Top