Populating textboxes based on criteria of combobox

[MTSPEER]

Hello,

Here is my scenario. I have a table(tbl_Queue) with 6 fields(Queue, Rep, First Name, Last Name, SSN, Date) and these fields are all unique except for the Rep field. And that is the field I want in my combobox. Once a user selects the name of the Rep I want it to populate the textboxes with the information of the first record. And I added record selector buttons on the form so the user can navigate through the records containing all the criteria based on the Rep. But I just cannot figure out how to do this. Do the textboxes have to be bound? I tried using the Dlookup function and doing it and it just shows all the records to navigate to. Your help would be greatly appreciated.
The combobox and texbox names are:

cmboRep


txtSSN
txtQueue
txtFirstName
txtLastName
txtDate

Thanks

[RuralGuy]

Start with a bound form and select #3 when adding the combo box.

[MTSPEER]

The textboxes need to be bound also?

[RuralGuy]

Sorry for the delay. YES, the Text Boxes should be bound as well. Is there some reason you don't want bound controls?