Selecting from a Drop-down List

[Guest]

I have a database to record our clients, their jobs, the project numbers,
etc. In a data entry form I entered a drop-down list from which users can
select a project manager's name. All of the project managers are listed in
their own table--with their employee number--and this is set up in
relationship to the form's table and the main table. When I select a project
manager's name from the drop-down, it doesn't put his name in the box...it
just looks at me like I'm an idiot. The same thing happens with my drop-down
list for client names. Again, I have a single table listing all of our
current clients, and the table contains only the client's name and his
number. To complicate matters, I have a separate field, with no drop-down,
for the client number, which I want to have completed based on the client
name. I apologize for being so wordy. I know the answers must be out there
somewhere. I'd appreciate any help you can give me. Incidentally, I do not
know anything about Visual Basic code as it operates in Access.

 

[ruralguy via AccessMonster.com]

I believe you need to "bind" your ComboBoxes to a field in the form's
RecordSource (table/query). Go to the Data tab of the properties sheet for
each ComboBox and set the ControlSource from the drop down.