MeowserM
asked on
syntax to reference a combobox field on a subform
Hello:
I have a form with a tab control on it. In the tab control I have several subforms. On the one subform I have a combobox field. I am trying to write some vba code that says if the combobox field is null then display a message. I have tried this several ways but I think I am not using the correct syntax to reference the combobox field. I have a suspicion that I don't have the right subform name.
Here is the code I have right now:
If IsNull(Forms!FrmAudit!Audi
MsgBox ("You must enter something in AuditElement field")
Else
End If
Thank you in advance
I have a form with a tab control on it. In the tab control I have several subforms. On the one subform I have a combobox field. I am trying to write some vba code that says if the combobox field is null then display a message. I have tried this several ways but I think I am not using the correct syntax to reference the combobox field. I have a suspicion that I don't have the right subform name.
Here is the code I have right now:
If IsNull(Forms!FrmAudit!Audi
MsgBox ("You must enter something in AuditElement field")
Else
End If
Thank you in advance
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks again
ASKER
Thank you!!