I have a a form called "frmMain" I have a subform called "frmInductionChecks".The subform is located on one of the tabs of the main form.
I know that the structure of this form is horrible! but This is the best I could do.
On the button called" Save record" it has two queries that append One for the main form Called "frmMain": DoCmd.OpenQuery "qryappendInductionHistory
", acViewNormal, acEdit
and one for the SubForm "frmInductionChecks" DoCmd.OpenQuery "qryappendInductionChecksH
istory", acViewNormal, acEdit
The append queries have a code on the criteria that suppose to append only the data that it is in each of the form the code in the criteria looks like this for the main form,
and this for the subform, [Forms]![frmInductionCheck
The field for the both forms is "serial".
The main form is appending. but the subform popups showing the criteria,[Forms]![frmInduc
like it cant find the form. Experts please help!
Thanks for all your time and help!