Arrgh, search form on duplicate names

fluffyozzy

Registered User.
Local time
Today, 13:10
Joined
May 29, 2004
Messages
63
Could anyone help me please?

I have incorporated a search form (previously posted on this forum) and it is not cooperating when there's a duplicate name on the listbox. There can be more than one, say, John Smith on the database. In order to differentiate between two John Smiths, I need to be able to see their date of birth, where they are and who assessed their work.

So, I type the name John Smith on the search box, list box shows me all the John Smiths in the database, but only shows the first John Smith's details on the relevant fields on the form. What I would like to do is to be able to click on each John Smith's name on the listbox and see their details on the relevant fields. Attached db is Access 2000.

Any help will be much appreciated. Thanks in advance :)
 

Attachments

THANK YOU!!

This is perfect. So I should have got the listbox to populate by ID number rather than name.

I really appreciate it, lots of karma points for you, and less gray hairs for me for today :p
 

Users who are viewing this thread

Back
Top Bottom