Forum Discussion
Form and Subform
I have a main Form named frmProjQry. Within this main form, I have 5 subforms. One subform is named sfrmWO (based on tblWO) while a second is named sfrmALbr (based on tblALbr). I want sfrmALbr to ...
run your query to find out if it has error.
you may also use this as your Criteria:
...
...
WHERE (NOT ((tblALbr.[Cost Element]) IN (890001, 890002))) AND (([tblWO].[WOOrder])=[Forms]![frmProjQry]![sfrmWO].Form![WONo]))