Hello,
How do you add a new record to a subform base on the value of a text box on
the main form?
Floyd
Please explain. What is the Recordsource of the subform? of the
mainform? Where do you want the data entered?
You can - and this *might* be what you're asking - set the Master Link
Field property of the Subform control to the name of a mainform
textbox (the wizard won't give you this choice but you can simply type
the name of the control into the property); set the Child Link Field
to the field into which you want that value stored. When you create a
new record (by inserting anything into any other field) the value in
the textbox will be automatically stored in that field.
John W. Vinson[MVP]
