Call popup from query. 1

[katiekat]

Hi there,

I have a report in which I would like to limit the records shown depending on the user selection from a drop down list. What seemed the right way to do it was make a form with the list, then point the field in the query behind the report to the popup.

I've got the form, I've got the query. I'm not sure what to put in the query to make it work. I tried this:

[Forms]![PopUpForm]![popup]

and this

=[Forms]![PopUpForm]![popup]

But both just throw up a dialog box for entering a parameter value with that on it. No worky.

I would appreciate some help!! THANKS!
Kate Holy tek-tips batman!:-0

 

[Celeste025]

I have criteria in my queries that create a popup before the query is run. There isnt a handy drop down, but I have to type in the information. In the criteria field of the column you want filtered type something like this:

LIKE [Enter Agent Name or * for All]

The information inside the brackets is exactly what will show in the popup and it will then filter the query by what is typed. The asterisk works both as a wildcard for all and also for shortcuts or spelling questions.

 

[CosmoKramer]

If the popup you are referring to is a list box then try this:

* Add an invisible text box to your report.
* In the AfterUpdate event of your list box, put code like this:
Me.txtInvisible = Forms![YourForm]![YourListBox].Column(0) 
* Add txtInvisible to be the criteria in your query

Hope this helps....

 

[katiekat]

CosmoKramer....

I'm sorry, but I don't really understand what you're telling me here. Could you explain in a little more detail?

Thanks!
Kate Holy tek-tips batman!:-0

 

[CosmoKramer]

The first two steps will take the value you clicked on in the list box and place it in the invisible text box. The third step defines the value in that text box as the criteria for your query.....