Edit Record 2

[Nene75]

Hi Everyone:

I am trying to edit the record by selecting the last name of the record. I would like the matching record open where I can make modificaitons. But when I select the last name from the drop down menu I am getting blank Data entry form rather ... what am I doing wrong?

Please help!

Thanks!

 

[Nene75]

The problem is solved with the following solutions:

I have the following SQL statement on the row source of combo box (cboFullName):

SELECT [tblApplicantBioData].[ApplicantID], [tblApplicantBioData].[ApplicantLastName] & ", " & [ApplicantFirstName] & " " & [ApplicantMiddleInt] AS FullName FROM tblApplicantBioData ORDER BY [tblApplicantBioData].[ApplicantLastName] & ", " & [ApplicantFirstName] & " " & [ApplicantMiddleInt];


I have the following VB Code for the After Update Event:

Private Sub cboFullName_AfterUpdate()
DoCmd.OpenForm "frmApplicantData", , , "[ApplicantID]=" & Me.cboFullName
DoCmd.Close acForm, "frmResumeSelector"
End Sub

Thanks docmeizie and Ronald for your help.