still cannot fill in other field from a dropdown list

  • Thread starter Thread starter Michael
  • Start date Start date
M

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
 
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
 
Michael said:
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
Click to expand...

Check the ColumnCount property on the ComboBox. It is not enough to have the
additional columns in the RowSource.
 
Thank you Rick.. that did it.
Michael

Rick Brandt said:
Michael said:
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
Click to expand...

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