Text box values from previous control

[chilepepper]

I am trying to get a value to show in various text boxes after a value is entered in a combo box. In particular when a vehicle number is selected in the combo box it would complete fields showing the tag number, vehicle make and modl boxes filled in automatically. There are tables setup with all of this info. I have seen explantions of how to accomplish this in various premutations but I don't understand what to do with code that has been posted. I am very new to this process and don't have much insight.

Thanks for any help!

 

[pbaldy]

Include all the fields in the row source of the combo. Have this as the control source of the textboxes:

=ComboName.Column(x)

where x is the column containing the desired value.

 

[chilepepper]

Syntax error

Thanks for input. I tried that and it returned with syntax error. I double checked the typing (I am a messy typist).

Any further ideas?

 

[chilepepper]

OK I got it to work The problem was with the combo box.

Thanks