I am accessing different forms from different databse through my main database by clicking with different buttons. The code is listed below. The problem is when accessing the forms from another databse from my main database the form is displaying fine and when i switch another application which minimized and came back to access the form again it hanging and i need to restart to access to open the form again.
Can anyone help plz..
Dim objAcc As New Access.Application
objAcc.OpenCurrentDatabase "\\networklocation\\aa.mdb", True
objAcc.DoCmd.OpenForm "FrmName", , , , , acDialog
The form opens fine and when i switch back to another appln or minimize the DB and maximise it i couldn't access the form.