subform reference

  • Thread starter Thread starter Guest
  • Start date Start date
G

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)
 
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)
 
Thanks that worked. Actually it helped AFTER I changed the subform control
name to NOT be the same name as the subform. :-)
 
I did try that, didn't work. It may have once I changed the actual subform
container's name though.
 
Maurice said:
You can also use:

Forms!frmMember!sfrmBilling!Charges

That will work as well.
Click to expand...


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