Checkbox Query??

[janed]

Is it possible to make a query where a form pops up with checkboxes? i am amking a query for different types of phones and i want the user to be able to select more than one phone at a time? ne ideas??

thanks,

jan

 

[Memnoch1207]

If you can give me a visual on exactly what you want to happen I can try to help you.

 

[janed]

i want a parameter box to appear that contains the name of eight differeent types of phones. i want the user to be able to query one or more types so i thought the most efficient way would be with check boxes. is this possible?
as it is now i have the paramenter box but the user must choose a buttone rather than a checkbox and therefore can only query one at a time.
pls help!!!

 

[TessB]

I have not tried this, but I think the query parameters would go something like this:

If frmPopUp.ckPhone1 = vbchecked then fldPhone = "Nokia"
OR
If frmPopUp.ckPhone2 = vbchecked then fldPhone = "Motorola"

Etc.

As I said, I haven't tried it, but that should at least get you moving in the right direction. Hope it works!!

Tess

 

[David R]

http://www.access-programmers.co.uk/ubb/Forum7/HTML/003528.html