AddNew Records.

  • Thread starter Thread starter Floyd Forbes
  • Start date Start date
F

Floyd Forbes

Hello,

How do you add a new record to a subform base on the value of a text box on
the main form?

Floyd
 
Hello,

How do you add a new record to a subform base on the value of a text box on
the main form?

Floyd
Click to expand...

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]
 
Back
Top