1 more question re Forms

  • Thread starter Thread starter .
  • Start date Start date
?

.

My Form with a combo box to select the criteria used for a Query & a Run
Query & Preview Form buttons on it. My qstn. is how to auto-close the Query
Form after it has run?
Thanks in advance,
Me-oka.
 
My Form with a combo box to select the criteria used for a Query & a Run
Query & Preview Form buttons on it. My qstn. is how to auto-close the Query
Form after it has run?
Thanks in advance,
Me-oka.
Click to expand...

If you are opening the query from a command button on the form, just
close it right after you open the query.

DoCmd.OpenQuery "QueryName"
DoCmd.Close acForm, Me.Name
 
Back
Top