Capturing a value from a subform

[bogglebeats]

Hello. I am trying to update the value on my Client Stages (main form). The value should be equal to the Name field on my Service Provider (subform). Once the name value is recorded in the subform i would like this value to appear in the SP Name field in my main form. How would i do this?? thanks.

ameen

 

[Oldsoftboss]

Presuming the record in the subform is the last record you can try the following:

Forms!MainFormName!SubFormName.SetFocus
DoCmd.GoToRecord , , acLast
Me.MainFormField = Forms!MainFormName!SubFormName!FieldName

 

[Oldsoftboss]

I use this method as service providers change from time to time and it is good to keep a history of who you used and when. This is only one field in the main form which is usually linked to a service providers table as opposed to setting up a juntion table. Probably shows my lack of understanding of Access.