VBA form help

[RuralGuy]

Excellent, and nothing is hard coded. See, that wasn't so tough.

 

[RuralGuy]

BTW, for the benefit of others reading this thread, it would be nice if you would tell us what exactly did to finally get the code to work as you wanted.

 

[labonte373]

SELECT [CarNumber], [Car/Serial Number], [Model], [Type] FROM [Car Numbers]; per your suggestion

I added 4 columns with widths of 1";0;0;0;


Private Sub txtModel_Click()
Me.txtModel = Me.cboNumber.Column(1)

End Sub

 

[RuralGuy]

It looks to me like your ComboBox will display only the [CarNumber] field and your txtModel control will be filled with the [Car/Serial Number] rather than the model you were talking about.

 

[labonte373]

The cboNumber displays the car/serial number and the txtModel displays the model.

 

[RuralGuy]

Thanks for posting the solution.