Modal Popup Query

[gold007eye]

Is it possible to make a query Pop-up? All of my forms are set so the Database background is hidden and they popup. I haven't been able to figure a way to do this with a query. Any help or suggestions would be great

 

[KenHigg]

Can you get what you need if you do a new form based on this query and set its 'Default View' to 'Datasheet'?

 

[gold007eye]

I had thought of that except If I use a form I need it to be able to handle which ever query is being selected.

 

[KenHigg]

You can tell the form which query it should be based on with code as/when it opens... Would this work?

 

[gold007eye]

How would I write code to know which query to use? I think that this method would work

 

[KenHigg]

Is it safe to assume that there will be a set number of queries you will be using and that this set of queries shouldn't change?

 

[gold007eye]

That would be the assumption, but the number of queries could change in the future (if I am asked to create another query type report that is)