How to reference a field on a subform

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave - 10 Mar 2008 03:10 GMT

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

Reply to this Message

Beetle - 10 Mar 2008 03:50 GMT

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

Signature

_________

Sean Bailey

> Access 2003
>
[quoted text clipped - 8 lines]
> Thanks in advance
>

Reply to this Message

Dave - 10 Mar 2008 04:06 GMT

Thank you

dave

> 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
[quoted text clipped - 13 lines]
>>
>> Thanks in advance

Reply to this Message