Ok, that would work but what if you have several combo boxes? How can I show records from the main form with the properties selected in the combo boxes when this data is stored in the subform?
If only I knew the answer to this! I've been wrecking my brain trying to figure out a way to do this. Please, there must be someone out there... How do u filter a main form's records by data on the subform??
Thanks for all this Abby and Kevin.
Abby, please could you send me a sample database to get an idea of what I should be doing. I'm using Aceess 97.
Thanks again for all your help.
Ok so let's say I do that. How can I filter the records by the check boxes they have selected but also include the records with these and other boxes ticked also?
Thanks in advance.
Please can someone help me. I am trying to have some sort of reference database for photographs. I have a number of fields on a form which are check boxes with field names to describe each photograph. E.g. landscape, sea, close-up, animal. Each photograph having between one and 10 boxes checked...