DoCmd.Close...Closing all my forms!

  • Thread starter Thread starter trekgoes2malaysia
  • Start date Start date
T

trekgoes2malaysia

Occassionally, when running code in VBA, the "DoCmd.Close" command
ends up closing all the forms I have open in my Access database file
when all I want it to do is close the form or query I last opened with
the DoCmd statement. Why is this happeing and how can I avoid it in
the future?

Example below:

DoCmd.OpenForm stDocName,,,stfilter
getathlete = Me!fname
DoCmd.Close
 
Occassionally, when running code in VBA, the "DoCmd.Close" command
ends up closing all the forms I have open in my Access database file
when all I want it to do is close the form or query I last opened with
the DoCmd statement. Why is this happeing and how can I avoid it in
the future?

Example below:

DoCmd.OpenForm stDocName,,,stfilter
getathlete = Me!fname
DoCmd.Close
Click to expand...

Specify the object you want to close explicitly:

DoCmd.Close acForm, stDocName
 
Specify the form to close, e.g.:
DoCmd.Close acForm, stDocName
or to close the current form:
DoCmd.Close acForm, Me.Name
 
Back
Top