The code I am using on the close button is as follows:
Private Sub cmdMenu_Click()
Unload "frmViewDetails"
DoCmd.Close
DoCmd.OpenForm "frmMenu"
End Sub
Private Sub cmdViewList_Click()
DoCmd.Close
DoCmd.OpenForm "frmListPatientOrders"
End Sub
I thought the Unload even took place before the Close so would think that
the form is unloaded at this point. Is that wrong?
Mike
"Phobos" <la******@spammers.co.uk> wrote in message
news:ma********************@brightview.com...
It usually helps us to help you if you post some code...
That said, I suspect that you are not unloading the form from memory,
merely hiding it. Look up "Unload" in help.
P
"Mike" <re******@hotmail.com> wrote in message
news:3f********@dnews.tpgi.com.au... I recently posted a question regarding a table built using an action
query in VBA. I am still having trouble. I have tried saving a record as
suggested by one post.
The problem
A form uses the new table as its recordsource. However, even when the
form is closed using either the close button on the form title bar or using
the docmd.close the form fails to release its connection to the table making
it locked and unable to be dropped or edited prior to the next create table
sql command.
I have looked everywhere for a solution without success.
Any suggestions?