dynamic query using checkboxes

[yessir]

i have a form with a billion check boxes,

i need to run a query with a button based upon the boxes checked...

i tried modifying other ones that use combo boxes but it doesn't work

could someone code the button for like Yes and No search of a table from checkboxs?

 

[Hayley Baxter]

Just as a matter of interest why do you have a checkbox for yes and a checkbox for no, why not just use one and if it's ticked it's yes and if it's unticked it's no? or was that just an example?

 

[yessir]

example

i get that, this is just an example
i have like 50 on the form i want to use,
this is just so that ppl replying don't have as much to work with,

ie, less work for you may mean you'll help!

 

[Hayley Baxter]

Sure no probs I've used checkboxes with QBF before so I'll have a look for you this evening if that's not too late for your time schedule.

On seconds thoughts I do have something I can send you to loo at (one I made earlier ) I'll delete the confidential stuff first and post back.

 

[yessir]

thanks

 

[Hayley Baxter]

which version of access would you like it in?

 

[Hayley Baxter]

Access 2000 Version

Leaving all check boxes blank will return all records. I have sent the results to a report that I drew up very quickly so sorry for it being messy.

Any problems let me know
Hay

 

[yessir]

thanks

thankyou,

i am using XP so i hope it works

just wondering, did you just add a button and set the stuff ur self, cause every tin=me i add a button the wizard opens

 

[yessir]

sorry

again, how did you set up the query, just in the command button code?

 

[yessir]

1 more

how come there are the hidden text boxes,

may be simple, just trying to understand

kinda new
..

 

[yessir]

PLZ HELP

Here !

 

[Hayley Baxter]

Ok I've had a look at your database. You haven't copied the module over from my program to yours that's where your problem lies. Copy this over and see how you get on with that.