unbound field on subform of a tab page

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

Guest

I need to know how to correctly identify the
field of a subform that is on a tab of a form.

I have tried:
Forms![formname]![subformname].form![controlname] ; didn't work

forms![mainform]![subformcontrol].form![controlname] ; didn't work

forms![mainform]![subformcontrol].form![nestedcontrol].form![control] ;
didn't work

forms![mainform]![subform].form![controlname] ; didn't work

All I am trying to do is find a record in the dbs, pull a particular field
value (which works since debug shows me the value correctly) and load it into
an unbound field on a subform that is on a tab page of a form.

I know that I must be close the the correct syntax. I feel like I have
tried everything but what works.

DT
 
The Name of the subform control may be different to the name of the form it
contains (its Source Object.)

1. Make sure the boxes are unchecked under:
Tools | Options | General | Name AutoCorrect
We don't want them interferring with the names.

2. Open the main form in design view.
Right-click the edge of the subform control, and choose Properties.
What is the Name property (Other tab)?

If the main form is named "Form1", and the subform control is called
"Child1", and the control in the subform is named "Text0", try:
Forms!Form1!Child1.Form!Text0
 
Back
Top