Using results from a subform to populate the main form

[andrewhoddie]

Hello

I have a main form called Handyperson to log all enquires relating to this service. Each time a customer or potential customer rings up it is logged on this form. On this form there is a search button. I have a subform called search which has a search facility and the results are shown on a second subform called ServiceUsersSearchList returning data from table customerdata.

what I would like the search form to do is where there is a matching customer to populate the fields on form Handyperson such as title, forename, surname address and contact number on the click of a command button. if there is no matching customer then the user would fill this detail in manually.

I am a bit confused as to what the code for this would be for the event on click. If anyone has any ideas I would be very grateful

many thanks
Andrew

 

[andrewhoddie]

I have tired

Private Sub Command7_Click()
Forms![Handyperson].Form.SetFocus
DoCmd.GoToRecord , , acNewRec
Me.Refresh
If IsNull(Surname) Then
'do nothing
Else
Forms!Search!ServiccUsersSearchList!Title.Value = Me.Handyperson.Title.Value
End If
DoCmd.Close
End Sub

but I get a compile error saying method or data member not found. can anyone help?

thanks
Andrew