still cannot fill in other field from a dropdown list

[Michael]

I have the following in my "ProductID" text box control source "me!ProductID
= ProductName.column(1)"

my sql for the "ProductName" Dropdown list is

SELECT Products.ProductName, Products.ProductID, Products.ProductionPerKilo,
Products.SemeCode FROM Products;

I get #Name? in the text box.



thank you
Michael

 

[Guest]

The control source should just have
=ProductName.Column(1)

 

[Michael]

thanks

The control source should just have
=ProductName.Column(1)

 

[Michael]

Hello would there be a reason that it only works with the first column? I
have 4 columns in the dropdown list (only the 1st column showing in the list
and I am using

=[ProductName].[Column](1)
=[ProductName].[Column](2)
=[ProductName].[Column](3)
=[ProductName].[Column](4)

The info shows in the first text field, but all the rest are blank. If I
change the third text field to =[ProductName].[Column](1) and move the
location of the 3rd field to the second column (0) being the first, it will
show the correct information.
thank you
Michael

 

[Rick Brandt]

Hello would there be a reason that it only works with the first
column? I have 4 columns in the dropdown list (only the 1st column
showing in the list and I am using

=[ProductName].[Column](1)
=[ProductName].[Column](2)
=[ProductName].[Column](3)
=[ProductName].[Column](4)

The info shows in the first text field, but all the rest are blank.
If I change the third text field to =[ProductName].[Column](1) and
move the location of the 3rd field to the second column (0) being the
first, it will show the correct information.
thank you
Michael

Check the ColumnCount property on the ComboBox. It is not enough to have the
additional columns in the RowSource.

 

[Michael]

Thank you Rick.. that did it.
Michael

Hello would there be a reason that it only works with the first
column? I have 4 columns in the dropdown list (only the 1st column
showing in the list and I am using

=[ProductName].[Column](1)
=[ProductName].[Column](2)
=[ProductName].[Column](3)
=[ProductName].[Column](4)

The info shows in the first text field, but all the rest are blank.
If I change the third text field to =[ProductName].[Column](1) and
move the location of the 3rd field to the second column (0) being the
first, it will show the correct information.
thank you
Michael

Check the ColumnCount property on the ComboBox. It is not enough to have
the additional columns in the RowSource.