I'm using a form with multiple subforms for data entry. The field that ties all together is the ClientID (auto# in main table)
I'm not able to open that form to create a new record, because the Client ID doesn't yet exist.
I built a simple form (frm01_Clients_New) that does open to a new record, with just a few key fields.
I’d like to save the record, close this form and simultaneously open the main form (frm01_Clients_New2) for data entry. The query for that form looks for the ClientID field on frm01_Clients_New
here’s what I tried, but nothing happens when I click the button - and is there a better/easier way to do this?
Private Sub opnfrmnew_Click()
On Error GoTo Err_opnfrmnew_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frm01_Clients_New2"
DoCmd.OpenForm stDocName, , , stLinkCriteria
stDocName = "frm01_Clients_New"