Set the controlsource of the textbox = to the subform textbox you want to
grab, like:
=[Forms]![MainFormName]![SubformControlName].Form![Name of Textbox Control
on subform]
Make sure that the SubformControlName is the NAME of the subform control,
not the name of the subform. They are usually the same if the defaults are
used, but not always.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads http://www.datastrat.com http://www.mvps.org/access
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.