Pop Up Prompt?

[floydpepper]

Ladies and Gents,
I have a query that pulls 5 fields from a table and feeds a report. When I open the report, I want a pop up form to allow the user to specify criteria for three of the fields. I followed the instructions from HELP and entered Forms![FormName]![Field] in the criteria. Once this actually brought up the form that I built with fields (unbound) to enter the criteria and it worked. After that, it always pops up a different form that I did not design. This smaller form is helpful on some queries, but I want the user to select the criteria from a combo box and a checkbox for this issue.

How do I make a query utilize a pop up form that I design? Thank you in advance.

FloydP

 

[PHV]

How do I make a query utilize a pop up form that I design
By taking parameters from that form only in the criterias.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[floydpepper]

Roger that. I created the form and the query. When I type [Forms]![MyFormName]![CriteriatxtBox] in the criteria section for the query and I run the query, a different form pops up (different from my design). How do I make it pull up my form? Thanks.

FP

 

[PHV]

The form must be open when you launch the query.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244