populate a textbox from a subform

T

Terran

i need to populate a textbox in the main form using the record selectors in a
subform
 
A

Arvin Meyer

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
 
Top