How to reference a field on a subform

D

Dave

Access 2003

Example:
If IsNull(Forms!frmEditDispatch.articles) Then

the field "articles" is not actually on the form "frmEditDispatch" but a
subform ("subEditPickup") attached to the form


How do I correctly refer the the field "articles"?

Thanks in advance
 
B

Beetle

You refer to the main form, then the subform control (which may or may
not have the same name as the subform itself), then the subform within
the control, then the control on the subform. The syntax looks like this;

Forms!frmEditDispatch!subEditPickup.Form!articles
 
D

Dave

Thank you

dave

Beetle said:
You refer to the main form, then the subform control (which may or may
not have the same name as the subform itself), then the subform within
the control, then the control on the subform. The syntax looks like this;

Forms!frmEditDispatch!subEditPickup.Form!articles
Click to expand...
 
Top