after updating a field in the main form, need to populate a field

[csunsun]

after updating "Service Provider" in my main form, i need to update "Service Provider" in subform 1 and also update "Service Provider" in subform 2.

i thought this code would work:

Private Sub Service_Provider_AfterUpdate()

Forms![Data Entry Form]![Service Provider] = Forms![Work Orders subform]![Service Provider]

End Sub

thanks for any help!!

 

[hneal98]

I am assuming that [Data Entry Form] is the main form, if that is the case, it should be like this:

Forms![Work Orders subform]!Form.[Service Provider] = me.[Service Provider]

You had it turned around.

 

[csunsun]

The code above gave me an error.

I tried this code as well and also got an error.

Forms![Data Entry Form]![Work Orders subform]!Form.[Service Provider] = me.[Service Provider]

any thoughts??

thanks!