Wrong information arriving in table.

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
 
R

Rick Brandt

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change Address Field data in a Table from a form using Combo Drop 7
Can I enter info from a dropdown box in a form to a table? 4
Dropdown list in a form to filter another form before it opens 2
How display info from one table, but save to another table 1
Creating a template for a standing order from a client 2
Slow Combo Box (intermittent) 1
Advanced dropdown list 4
Filter Query Dependent on Another Form Field 1

Top