Make Form Visible When Query Closed

[hext2003]

I have a form that gathers Parameters for a query.

I press a Search Button and I have code that sets my Form Visible = false and Shows the Query

If Someone Click on the X to close the Query I want the Form to be visible again.

How do I do that??? is it Possible? Where do I program this?

TIA

 

[dhookom]

Display the query results in a form. You can then use code in the On Close event of the query form.

Duane
Hook'D on Access
MS Access MVP

 

[Remou]

You should be able to use the timer event of the form.

Here is some sample code.

Private Sub Form_Timer()
intObjType = acQuery
strObjName = "Query1"
vS = Application.SysCmd(acSysCmdGetObjectState, intObjType, strObjName)
If vS = 0 Then Me.Visible = True
End Sub

Private Sub cmdShowQuery_Click()
    
    Me.Visible = False
    Me.TimerInterval = 100
    DoCmd.OpenQuery "Query1"
    
End Sub