Is there a better way to do this?

[The_Grudge]

I have a listbox on my form that is populated by data from Microsoft Access using a query/recordset. This query returns about 6 fields which include employee "FirstName" and "LastName" and "ID" which is a unique identifier.

Through code I make the entries in the listbox look like this...

Cruise, Tom
Gates, Bill
Gretzky, Wayne
Nicholson, Jack

and so on. This works perfectly.

I then allow the user to drag & drop names from this listbox onto a schedule on the same form that consists of about 55 textboxes.
The problem is that the listbox only contains the first & lastname of the employee because that's all I want the user to see. However, once a name is dropped into a textbox I need more information than simply lastname or firstname. I need the ID as well.

What I'm currently doing works fine but there has to be a better way.
Right now, once a name is dropped into a textbox I take the last name and do a ".Find" to find the record in the recordset I'm looking for. Then I have access to all the other info I need. It just seems silly to be manipulating strings and constantly searching for records. Maybe this is a good way, I don't know.

[RobCrombie]

Store the ID into the listbox's ItemData, then use that for more precision

[Hack]

Regardless of how you do it, searching for information relevant to the name being dropped is going to have to occur, so I don't see anything wrong with how you are doing it.