Are you still working on this one? You seems to have a lot of threads open on it. I could not figure out your status on this.
However this is how I do this in general. I build a form that produces me a long "where" clause, I do not use a parameter query. But this can be simple or very complext depending on how much flexibility you want. Normally I save this "string where" as a global variable so I can use this form as a front end on a lot of reports and forms.
However, you will need to describe what type of controls you plan to use, and which fields. Then describe how flexible you want to be. For example
Manufacturer Scale Autograph
lets say you choose "Mattel", "1:50" and "True".
1) simple would be find the records that matches any of these cases:"Or Case"
or the reords that match all of these cases:"And Case"
2) More complex would be to allow the user to mix and match. For example: Show all that are made by Mattel, and are 1:50. Or they have an autograph
3)More complex would be multiselect list boxes where you could create something like
Show all made by Mattel or Made by Hasbro, but are either 1:50 or 1:60, or Have an autograph.
So if your interested, povide me your status. Include the names of the pertinent tables, fields, and controls. Decide how complex the search needs to be. If it is just three fields, and it needs to match all three, that will be very easy. I have one I am using now with 6 multi select list boxes, and two option groups, and a checkbox. With just a few simple clicks, you can end up producing behind the scenes a where statement with 100s of criteria and conditions.