Might be asking the impossible...

[billythedj66]

Here is what I would like to do; While in a form (Form A), I want to create a macro for a button that when clicked, will close (Form A), and open (Form B) to enter data. Then when closed with another button, closes (Form B) then opens (Form A) at the original record. I am not sure if that makes any sense at all - if more information is needed please ask.

Bill

 

[smozgur]

Hi Bill,

You can use following method:

In click event of the command button on A form, you can put the following code:

Private Sub cmdAFormButton_Click()
  Me.Visible = False 'Hide form A
  DoCmd.OpenForm "B", acNormal, , , , acDialog 'Show form B, but use acDialog value so next line will be executed only when B form is closed
  Me.Visible = True  'B form is closed. Show me.
End Sub

For B form command button, you just need a close procedure.

Private Sub cmdBFormButton_Click()
  Docmd.close
End Sub

Record won't be changed in A form because we don't remove it from the memory, just hide it.

I hope this helps.

Suat