adding new record to subform

[carlton123]

I have a form with a subform (in continuous) I have on the main form a few unbound text boxes which once im happy with the results i press a command button on mainform which adds the unbound text boxes to a new record on subform im struggling with this one. I have done similar before but that was with the unbound text boxes in header of the actual form i was adding record too.

 

[JHB]

Insert the below code in the OnClick event for the button:

Me.YourSubformName.Form!YourControlName = Me.YourUnBoundControlName

 

[carlton123]

thanks just tried now im home and works think i must have been over complicating it before will get them all in and see if it works!

 

[JHB]

Happy to help, yes - don't make it more complicated as it is.