How can I use a form for the search parameters in a query?

[pgnl]

I can cope with simple queries by entering a parameter e.g. [Enter Category ..] in the criteria part of the query design. So when the query is run a small single line dialogue bix appears requesting thh required info.

How can I take this one stage further and use a Form (or Popup) of somet type to enter the search criteria?

This would be a much more elegant solution where say, you need three search criteria on three separate fields. Presumably this must be possible?

(I am a new to Access with no VB programming experience - I can however puzzle most things things out, even if it takes me a while..)

Thanks for your help.

Patrick
UK

 

[KyleS]

Patrick,

In the query (the same place you would put your "[Enter Category]&quot put this in:

[Forms]![YourFormName]![YourFieldName]

(Replaceing "YourFormName" with the actual name of your form, anf the same for "YourFieldName&quot

You can right click in that space and select "Build..." and it will bring up the expression builder, which let's you select functions, and/or fields. Play with it a bit and see what it can do for you! Kyle

 

[pgnl]

Thanks for that, i'll give it go...

Patrick
UK