B
Bill Murphy
I would like to open a table or query while in a form, and have the table or
query appear on top so I can view/edit its contents. But when I use the
following code the forms reappear instantly and the table or query is not
visible. Also, the app is frozen, and the user can't exit. The task has to
be ended.
Any thoughts will be appreciated.
Bill
_____________________________________________
Private Sub cmdOpenLocalTable_Click()
Me.Visible = False
Forms!frmMain.Form.Visible = False
DoCmd.OpenTable Me!cboLocalTables, acViewNormal
Me.Visible = True
Forms!frmMain.Form.Visible = True
End Sub
query appear on top so I can view/edit its contents. But when I use the
following code the forms reappear instantly and the table or query is not
visible. Also, the app is frozen, and the user can't exit. The task has to
be ended.
Any thoughts will be appreciated.
Bill
_____________________________________________
Private Sub cmdOpenLocalTable_Click()
Me.Visible = False
Forms!frmMain.Form.Visible = False
DoCmd.OpenTable Me!cboLocalTables, acViewNormal
Me.Visible = True
Forms!frmMain.Form.Visible = True
End Sub