Syntax for reference control on subform datasheet
Posted on 2011-09-29
On the main form, there is a print button. Before printing, I need to validate the subform field is not null.
subform is called "sbfrmTransaction"
control is called "cboEmployeeCode"
Here is my code:
If IsNull(???) Then
MsgBox "Employee code must be filled in before printing."
1) What would the syntax be in the IsNull(???)
2) Subform is a datasheet, do I have to loop through all the records to validate each of these fields?