hiding a query after opening a form based on the query

[billybeer]

I have a form that will run a query and open a form that uses that query as a record source. How do I hide the query so that the user only sees the form.



Thanks.

[isladogs]

This code will close a query

DoCmd.Close acQuery, "YourQueryName"

Alternatively you could run the query as a SQL statement so it would never actually be opened

[June7]

Why are you opening query object anyway? Just open the form.

[billybeer]

opening the query so that the table can be updated. I can close the query but I do that after the update, I just don't want the user to ever see it.

[isladogs]

opening the query so that the table can be updated. I can close the query but I do that after the update, I just don't want the user to ever see it.

So as already stated, convert your query to SQL and run that as code from your form - either in the Form_Load event or from a button click event
The user doesn't need to see anything happen whilst it runs

[billybeer]

Thanks, I will give that a try.

[ssanfu]

You can use a saved query... but instead of opening the query use

CurrentDb.Execute "YourQueryName", dbFailOnError