M
Musa via AccessMonster.com
I have the following code with Survey_ID as the PK. The Combo Box also
displays First Name , Last Name , and DOB. I want to search based on Last
Name and view the Survey_ID in the drop down of the combo box. I am able to
search Last Name if I leave the Column width for Survey_ID = 0". When I
change the column width for the Survey_ID to show in the drop down, I'm
unable to search by Last Name. The search switches to the Survey_ID. How
can I display Survey_ID, Last Name, First Name, and DOB in the drop down
combo box, but search just on last name ?
Private Sub Matchup_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[Survey_ID]= " & Str(Nz(Me![Matchup], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
Me.Matchup = Null
End Sub
Thanks...
displays First Name , Last Name , and DOB. I want to search based on Last
Name and view the Survey_ID in the drop down of the combo box. I am able to
search Last Name if I leave the Column width for Survey_ID = 0". When I
change the column width for the Survey_ID to show in the drop down, I'm
unable to search by Last Name. The search switches to the Survey_ID. How
can I display Survey_ID, Last Name, First Name, and DOB in the drop down
combo box, but search just on last name ?
Private Sub Matchup_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[Survey_ID]= " & Str(Nz(Me![Matchup], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
Me.Matchup = Null
End Sub
Thanks...