combobox to select a specific record, populate form

[cwfontan]

have a combobox with first, last name when user selects one I want to populate the rest of the form with that users data. My issue is I cant figure out how to assign the combobox a value/identifier for the record?

something like this is what I wish I could do  :P

ComboBox  select customer name  = 103,"Jones, Tim"   (recordID, "Last,First")

Select * from users where recordID = combobox.selectedValue? ? ?

how do I get the record for the name selected?

 

[cjard]

Just download the entire set of users and bind the combo. It will function as a navigator.

It was quicker to do an example than explain: