sub form access

  • Thread starter Thread starter bob
  • Start date Start date
B

bob

I have a field in the main form that will use a value in
the subform. in the main form i have rent and I will use
the utilityfee in the subform. so i create a control
named total and set the control source to
rent+subformname!utility. this expression worked in
office xp. but when i use it on office 2003, i will not
get the utility from the subform. I tried form!
subformname!utility and it won't work either. It is weird
it worked in office xp but not in office 2003.
 
Try:
=[rent] + [subformname].[Form]![Utility]
The equal sign is important, and the .Form bit will help.

If that still does not work, double-check to see if the Name of the subform
control on the main form is different from the name of the form that gets
loaded into it (its SourceObject).

The other case where this could fail is if the subform has no records, and
new records cannot be added. In that case, the subform will appear
completely blank, and attempting to refer to the non-existent text box will
fail.
 
Back
Top