populate text box based on cmb box

[nick404]

I have the control source for the text box set as =[CmbName].Column(1) (it doesn't work as is):


However, the data that the textbox should draw from is from a different table than the one the form is made for. I have a table "Product". In it, there is product names as the PK and a "target" (a number) as a second field. In the form I want the user to be able to select a product (cmb) and the 'target' text box to auto-fill with the correct target number that is found in the Product table [for the selected product]. However the form's record source is for another table.

EDIT: I have also tried =[Combo20].[Products]![Target]
And that does not do the trick either.

[pbaldy]

The first one should work. Make sure the column count property of the combo is at least 2. That assumes the row source includes that data.

[nick404]

So i should keep the first bit, as the text boxes control source or as a default value?

column count property of the combo is at least 2.

in the properties section?

[pbaldy]

Yes, like this:

BaldyWeb - Autofill

Column Count is a property of the combo; it needs to be set to the number of fields in the row source.