#Name?

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

Guest

I have a form named [frmPKsContainerFills] with a subform named
[sfrmPKsContainerFills]. This subform has the subform
[sfrmPKsContainerFillsOFs] with a control named [ml]. This control's source
is:
=[Forms]![frmPKsContainerFills]![mlConv]*[PercentVolOF]*0.01
This works fine.

Another control in [sfrmPKsContainerFillsOFs] is [Productg]. Its source is:
=[Forms]![sfrmPKsContainerFills]![SpecificGravity]*[ml]
This returns #Name?

[sfrmPKsContainerFills]![SpecificGravity] is 100% correct. Also, there are
no other controls with duplicate names.

Any ideas why #Name? returns? I've reviewed help but can't figure it out.

Thanks for your help!
 
If you are trying to refer to a control on a subform which is embedded in a
main form, you have to give Access the complete path. The subform isn't
being opened by itself, right?

The general approach is something like:
Forms!YourMainForm!YourSubformControlName.Form!YourControlNameOnSubform

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Good grief. Thanks for the very polite "DUH!"

--
www.Marzetti.com


Jeff Boyce said:
If you are trying to refer to a control on a subform which is embedded in a
main form, you have to give Access the complete path. The subform isn't
being opened by itself, right?

The general approach is something like:
Forms!YourMainForm!YourSubformControlName.Form!YourControlNameOnSubform

Regards

Jeff Boyce
Microsoft Office/Access MVP

JohnLute said:
I have a form named [frmPKsContainerFills] with a subform named
[sfrmPKsContainerFills]. This subform has the subform
[sfrmPKsContainerFillsOFs] with a control named [ml]. This control's
source
is:
=[Forms]![frmPKsContainerFills]![mlConv]*[PercentVolOF]*0.01
This works fine.

Another control in [sfrmPKsContainerFillsOFs] is [Productg]. Its source
is:
=[Forms]![sfrmPKsContainerFills]![SpecificGravity]*[ml]
This returns #Name?

[sfrmPKsContainerFills]![SpecificGravity] is 100% correct. Also, there are
no other controls with duplicate names.

Any ideas why #Name? returns? I've reviewed help but can't figure it out.

Thanks for your help!
Click to expand...
Click to expand...
 
Back
Top