DoCmd.Close...Closing all my forms!

[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

 

[Stuart McCall]

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

Specify the object you want to close explicitly:

DoCmd.Close acForm, stDocName

 

[Allen Browne]

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