VBA to close a form

[gheyman]

I have a button that brings me to a different form. How do I close the current form where the button resides?

Private Sub cmdRFPMgr_Click()
   
    OpenThisForm "frmRFPManager", Me.NewIDforRFPManager

End Sub

 

[gheyman]

I want to close frmPIDGenerator and then go to frmRFPManager all with the click of the button

 

[xenou]

Seems like this works (just a quick guess on my part):

Private Sub Command0_Click()
    DoCmd.OpenForm "Form2"
    DoCmd.Close acForm, "Form1", acSaveNo
End Sub

 

[Norie]

If the code is in the form you want to close you can use this.

DoCmd.Close acForm, Me.Name

 

[gheyman]

Thanks

What if I wanted it to also Refresh when the button was clicked?

 

[xenou]

Hi, not sure what you mean. The newly opened form is refreshed (de facto, since you are just opening it). The closed form cannot be refreshed.

 

[gheyman]

Got it - me.Refresh

I was not trying to refresh the form I was opening. I wanted a global refresh because other forms could be open that contain data from the from I was closing.

I appreciate the help.

 

[xenou]

I don't believe there is a global refresh. You'd have to refresh all open forms (one at a time, I mean). "Could be" is not very persuasive here. I wouldn't suggest doing this unless you need to - and even then, maybe you could instead set this up so you don't need to use refreshes this way.