G
Guest
Please help!
Employee form (data source is employee qry for active employees) has button
to call Note form (data source is table).
Code behind button OnClick:
Dim NewData, stDocName, stLinkCriteria
NewData = Me!CGID
stDocName = "frm3DE NoteAlert"
stLinkCriteria = "[CGID]=" & "'" & Me![CGID] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormAdd, acDialog, NewData
Code behind Load Event on called note form:
If Not IsNull(Me.OpenArgs) Then
Me!CGID = Me.OpenArgs
DoCmd.Save
End If
The called form is Yes to add/edit/delete and data entry.
OpenArgs passes the CGID to the called form successfully; the control's
source is the CGID in the table.
I am unable to save the record and cannot see why not. Can someone please
tell me what I am unable to see?
Employee form (data source is employee qry for active employees) has button
to call Note form (data source is table).
Code behind button OnClick:
Dim NewData, stDocName, stLinkCriteria
NewData = Me!CGID
stDocName = "frm3DE NoteAlert"
stLinkCriteria = "[CGID]=" & "'" & Me![CGID] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormAdd, acDialog, NewData
Code behind Load Event on called note form:
If Not IsNull(Me.OpenArgs) Then
Me!CGID = Me.OpenArgs
DoCmd.Save
End If
The called form is Yes to add/edit/delete and data entry.
OpenArgs passes the CGID to the called form successfully; the control's
source is the CGID in the table.
I am unable to save the record and cannot see why not. Can someone please
tell me what I am unable to see?