I have two tables:
tbl_Audit
AuditID <PK>
Auditor Name
etc
tbl_AuditDetails
DetailsID <PK>
AuditID <FK>
I have a form, frm_Audit, that is used to enter general info into tbl_Audit. This form also contains a subform, frm_AuditDetails, and this is used to enter the specifics of an audit. The Link Child and Master fileds are AuditID. I have another form, frm_Metrix, that is used to view all the items (by DetailsID) for each audit (AuditID). I placed this code in the double click event of the text box txt_DetailsID but everytime the text box is double clicked, a blank form, frm_Audit, opens.
DoCmd.OpenForm "frm_Audit", , , "forms!frm_Audit!frm_AuditDetails.Form!DetailsID = '" & Me.txt_DetailsID & "'"
What am I doing wrong?
tbl_Audit
AuditID <PK>
Auditor Name
etc
tbl_AuditDetails
DetailsID <PK>
AuditID <FK>
I have a form, frm_Audit, that is used to enter general info into tbl_Audit. This form also contains a subform, frm_AuditDetails, and this is used to enter the specifics of an audit. The Link Child and Master fileds are AuditID. I have another form, frm_Metrix, that is used to view all the items (by DetailsID) for each audit (AuditID). I placed this code in the double click event of the text box txt_DetailsID but everytime the text box is double clicked, a blank form, frm_Audit, opens.
DoCmd.OpenForm "frm_Audit", , , "forms!frm_Audit!frm_AuditDetails.Form!DetailsID = '" & Me.txt_DetailsID & "'"
What am I doing wrong?