Hello...When I click the the save record button on my subform, I would like to capture the value of one of the fields into a bound textbox on my main form, is this possible?...I am having trouble with referencing the forms..etc...I was trying something like this...

me.mysubform.form!boxstatus = form.currentstatus

thanks

Jack

Hi Jack,

I think you have the expression the wrong way round should be

me.currentstatus = me.mysubform.form!boxstatus


You would include this on the afterupdate of the boxstatus or however this field is updated.

Cheers
Darren

Hi Darren, thanks for your reply...the code you supplied works when the button is on the main form..however in this case the save button is on the subform, the error message "data member not found" comes up. I guess what I am trying to do is reference the main form from within the subform..when the user clicks the save record button it saves the current record in the subform and updates the text box in the main form at the same time

can anyone help.

many thanks

Hi Jack

If you are storing the data in the Subform WHY do you also want to store the same data in the Main Form?

Mike