How to reference a field on a subform

  • Thread starter Thread starter Dave
  • Start date Start date
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
 
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
 
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...
 
Back
Top