Access 97 Combo Boxes - TechRepublic
General discussion
August 15, 2002 at 02:10 AM
mra2

Access 97 Combo Boxes

by mra2 . Updated 23 years, 10 months ago

I have a form with names, addresses and ID Numbers. I created a Combo Box using the wizard to search for the Fullname (Lastname, Firstname). Here is the code that was written:

Sub Combo21_AfterUpdate()
‘ Find the record that matches the control.
Me.RecordsetClone.FindFirst “[FullName] = ‘” & Me![Combo21] & “‘”
Me.Bookmark = Me.RecordsetClone.Bookmark

End Sub

It seemed to work until I found a member Smith, John where there were 4 Smith, John ‘s. Of course each has a unique ID Number.

The Combo Box lists ALL 4 Smith, John ‘s but when you click on any of the 4, it ALWAYS finds the FIRST as the code says. I don’t want any navigation boxes to move from record to record.

Anyone have a fix for this?????

Thanks
Alan

This discussion is locked

All Comments