subform reference

[Guest]

I am trying to reference a field on a subform

Forms!frmMember!sfrmBilling!Form!Charges

What am I doing wrong? I get an error stating that there is not a "field"
called sfrm1 on the form frmMembers. (sfrmBilling is the object name for the
subform)

 

[Steve]

You have a bang where there should be a dot. Should be:
Forms!frmMember!sfrmBilling.Form!Charges

Also, sfrmBilling must be the name of the subform control on the main form;
not the name of the subform.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Guest]

You can also use:

Forms!frmMember!sfrmBilling!Charges

That will work as well.

hth

 

[Guest]

Thanks that worked. Actually it helped AFTER I changed the subform control
name to NOT be the same name as the subform.

 

[Guest]

I did try that, didn't work. It may have once I changed the actual subform
container's name though.

 

[Marshall Barton]

You can also use:

Forms!frmMember!sfrmBilling!Charges

That will work as well.

That's not supposed to work in A2003. The .Form (and
..Report) property was not supposed to be optional.