List box Items different than table

[a4aj]

I have a form to enter the data, a list box to reflect the data I entered in a table.

The idea is to click on an item in the list box and to populate the values back to the fields in the form.But something wierd is happening.

The data on the listbox and the data in the fields is different when I click on it.

If I am not making sense in words,have attached a sample of my project.

Anyhelp would be really really appreciated .

 

[boblarson]

Change the bound column to the ID field (you have to check it in the query to have it available, but you can set the width to 0" so you don't see it) and use your code to go to that ID as that is your primary key.

 

[a4aj]

Thanks I am trying....Can anyone plz help me just to pouplate 2 rows from a table to the listbox? If you see there are 4 records.But i need just 2 based on the date I entered.