Wrong information arriving in table.

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

Michael

I have a form that has a dropdown list that pulls the info from a table
(pesticide) with only two text fields, Pesticide and Tipo. There no numbers
at all in this table.

My sql for the dropdown list is
SELECT Pesticide.Pesticide, Pesticide.Tipo FROM Pesticide ORDER BY
Pesticide.Pesticide;
The list appears fine in the dropdown,

When I select one, I get a number in the table that relates to the position
of the pesticide in the list.
thank you for any insight
Michael
 
Michael said:
I have a form that has a dropdown list that pulls the info from a
table (pesticide) with only two text fields, Pesticide and Tipo.
There no numbers at all in this table.

My sql for the dropdown list is
SELECT Pesticide.Pesticide, Pesticide.Tipo FROM Pesticide ORDER BY
Pesticide.Pesticide;
The list appears fine in the dropdown,

When I select one, I get a number in the table that relates to the
position of the pesticide in the list.
thank you for any insight
Michael
Click to expand...

The BoundColumn property of your ComboBox is incorrect.
 
Back
Top