Combo box / Populating text box

[DJ100]

Having a problem. I have a combo box on a form that I use to select a vehicle from a table. (tblVehicles) there is another field in the table called category.

I have put a text box on the form and I would like it to display the value of the category field when the value in the combo box is selected.

Really struggling!

Help would be appreciated

 

[jlc28]

I just went through the same thing, Take a look at my posting for connecting two columns. That's exactly what I just did. It worked too.

 

[database]

Having a problem. I have a combo box on a form that I use to select a vehicle from a table. (tblVehicles) there is another field in the table called category.

I have put a text box on the form and I would like it to display the value of the category field when the value in the combo box is selected.

Really struggling!

Help would be appreciated

hi DJ... i just spend a lot of time doing that !>..

this is what i think you are looking for....

Thanks
dB

 

[database]

hi DJ... i just spend a lot of time doing that !>..

this is what i think you are looking for....

Thanks
dB

oops...there was one table missing....

this one is right !...
hope this helps !

thanks

 

[DJ100]

Thank you

Got it working - at last - idiot here forgot first column in combo box is column 0 - was trying to populate the text box with a column that doesn't exist!

Thanks for your help

DJ