Lookup woes

[ABreeze]

I have a form with a subform containing several check boxes. Each check box references a particular stone and the user may chose several. I'm now finishing a lookup form to enable users to locate particular records. If someone wants to lookup all records where a particular stone was selected, how can he do this.

 

[afloyd]

you can develop a query to base the lookup form upon. Set the query field criteria for that particular stone to true and the query will only return the records with that stone checked.

I've used this technique with classes that our company teaches. That way we can track who has attended which (or all) classes.

HTH

-Al