Refer to textbox on dynamic subform (SourceObject)

[peterworm]

Hi,
I use a mainform with three dynamic subforms. I chance the SourceObject of an invisible subform with controlbuttons to one of the three subforms.
Me!frmSubInvisible.SourceObject = "frmSubVisitA"
On the Subforms is a unbound textbox with contains a string defined this way:
afterUpdate
forms!frmSubVisitA!outletNumber =
forms!MainFormVisit!OutletNumber

There a other bound textboxes on the subform.
Now I want to store the string of the unbound textbox in the same table the other textboxes on the subform are bound to.
Thank you for any help.
Peter

 

[dhookom]

Change its control source from nothing to a field in the subform's record source.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.