unbound field on subform of a tab page

D

DT

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
 
A

Allen Browne

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top