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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subform 7
Main Form and two Subforms 2
Use field to update multiple fields 4
How to always get the top level form reference, when calling from any subform/subform... 0
Total Field on Form using Subform Total Field Value 10
Need help on how to pass calculated field from a form to another form 0
Code not finding subforms 1
Click a subform field to open relevant form 5

Back
Top