On my main form (frmMain) I have an unbound combo box (cboSelectClient) where a user can select a record and details about that client appear in a subform. On the main form I also have a button which, when clicked, takes the user to the installation form (frmInstallations) and opens at the same client record. The code is...
DoCmd.OpenForm "frmInstallations", , , "[cboSelectClient].Value= '" & [Client] & "'"
DoCmd.Close acForm, "frmMain", acSaveYes
This works very well.
I would now like to put a button on the installations form which will take the user back to the main form and to the same client record.
Despite many attempts, I can't seem to make this work.
Is there someone that can please help me with how I might be able to do this?