Help!-Combo Problem

[Malta393]

Can anyone tell me how to set-up a combo box which when the field is selected automatically completes 3 other fields related to that selection.
e.g Combo box:First name when 1st name selected

Surname and Dept is completed automatically-so the user doen't have to type it in?

Any Help very much appreciated

 

[930driver]

You can add the Surname and Dept to the combo box query, then set the column width to zero as appropriate. In the after update event you can get the hidden colums using the column property of the combo

Me.Dept = me.cboName.Column(4)

Remember, columns are Zero based, so the first column is (0).
"The Key, The Whole Key, and Nothing But The Key, So Help Me Codd!"

 

[Malta393]

I,m not sure I have explained myself correctly.

I have a form with the fields first name,surname,dept on a
Orders form. I want the user to select the first name from a combo box and the surname and dept automatically be filled in so the user does not have to type in these details on the order. The sales managers table is related to the orders table(1 to many) if this helps

Thanks for your help
appreciated as I am nearing the points of insanity.