You can write the macro code to open and close the previous form. Then call it from the button click.
VB Code:
'Behind Main form: Option Compare Database Private Sub cmdCustome_Click() DoCmd.OpenForm "Customer", acNormal, "", "", , acNormal 'Show desired form DoCmd.Close acForm, "Menu" 'Close Main form End Function 'Behind Customer Form: Option Compare Database Private Sub cmdBackNav_Click() DoCmd.Close acForm, Me.Name 'Close current form DoCmd.OpenForm "Main", acNormal 'Return to Main form End Sub





Reply With Quote