Query criteria cannot reference subform

[stretch66]

Hi,

Trying to run an append query for a specific record on a subform but won't recognise the subform control.

The Master form is fmSickEdit do I have to reference the Master file in the SQL?

The SQL for the query is:

INSERT INTO tblDisLetter ( SickID, DateAdvisedDisciplinary )
SELECT tblSick.SickID, Date() AS [Date]
FROM tblSick
WHERE (((tblSick.SickID)=[Forms]![fmsubSickListEditVersion]![SickID]));


Thanks

 

[stretch66]

Tried this in the criteria but still didn't work.....anyone?

[Forms]![frmSickEdit]![fmsubSickListEditVersion].[Form]![SickID]

 

[Rich]

Use the code builder to get the Form/subform references correct