Autofill Fields on a form

[Malta393]

In anticipation-A big thanks-First i have no idea about VB.
I have 1 combo box and 2 unbound fields-the combo on drop-down shows 3 columns showing 1st and last name and a account number. On selection i need it to place the last name and account no into the other 2 unbound text fields to save the user from having to do this-the Managers table in linked to the orders table and all the above fields are on an orders form. CAN ANYONE HELP-PLEASE BE CLEAR-BECAUSE I AM GETTING BRAIN-DEAD%-

 

[JoanneM]

Afternoon

OK you have your combo box for th purpose of this exercise I am going to call your

combo box cmboID
Txtbox1 TxtFname
txtbox2 TXTLname

on the after update event of the of the combo box
copy the following

me!txtFname = me!cmboid.col(0)
me!txtLname = me!cmboid.col(1)


This should help


regards

jo

 

[JoanneM]

Afternoon

OK you have your combo box for th purpose of this exercise I am going to call your

combo box cmboID
Txtbox1 TxtFname
txtbox2 TXTLname

on the after update event of the of the combo box
copy the following

me!txtFname = me!cmboid.column(0)
me!txtLname = me!cmboid.column(1)


This should help


regards

jo