Close Form

[FoxStudent]

Is there anyway of storing the name of the calling form? So when the user closes the immediate form they return to the form they called it from. thank u

Grainne

 

[PaulF]

you can create a public variable then store the name of the form to it using Me.Name prior to opening the new form


strFormName = Me.Name
DoCmd.OpenForm ("NewFormName&quot
DoCmd.Close acForm, strFormName



then in the close event for the 2nd form use

DoCmd.OpenForm strFormName


PaulF