Form question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to design a form in my employee's database and I want to get a
drop down box that will show the employee number and name and when selected I
want it to update their last name and first name. Can anyone help?
 
In the combo RowSource include all the fields you want to display in the form

Select ID , [last name] , [first name] From TableName

Use the column width to hide the column you don't want to display when the
combo run.
In the text box's you created in the form, where you want the rest of the
details to be displayed write

for first name:
=[ComboName].Column(2)

for last name:
=[ComboName].Column(1)

========================
The column number in the combo start with 0
 
Back
Top