Open Query in Hidden Mode

[DBFIN]

I have a complex form that reads data from other queries and forms. These other queries and forms are opened automatically via an embedded macro in the on load event. I want to open the queries in a hidden mode so the user does not see the query. There are options to hide a form, but I don't know how to hide a query.

How do I hide an open query by selecting a standard option in the action catalog ?

 

[bob fitz]

Why are you opening a query if you don't want to see it.

 

[DBFIN]

My primary form must read a value from a secondary form. The secondary form reads a value from the query. The secondary form and query must be open for the primary form to extract the value.

 

[bob fitz]

The secondary form reads a value from the query.

How does it do this?
What does it do with the value?
Can't you get this value using DLookup() ?

 

[DBFIN]

I will try dlookup function and see if this eliminates the need to open a query. Thanks for your input. I'll let you know if I run into any stumbling blocks.