COMBO BOXES

[Malta393]

FORM:I need a Combo box that when selected fills in another
field on the form

e.g First Name(combo)
Selected First Name :Bob
Fills in Surname Field Automatically

Any Ideas

Cheers

 

[rushdib]

Hi,
In the After Update event of the first name combo box, enter Me![Surname text box] = Me![first name combo box].Column(1)

Column(1) is the second column of the combo box which is the surname.

 

[LittleSmudge]

rushdib's solution does require the surname to be in the second column on the combo box

So the RowSource on the combo will need to be something like

RowSource = "SELECT firstName, surName FROM tblNames"
BounndColumn = 1
ColumnCount = 2


G LS