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