List Box Problem

[Ben Perez]

I am having a problem with my list boxes on a form. They
are showing the correct values from the table, but when I
change the list box selection on the form it doesn't
write the information to the table. Also, if I write
information to the table manually, then edit it with the
form list box it clears what what written previously.

The list box is a referencing two columns of data from a
table - only showing the second column, but is bound to
the first column.

 

[Graham R Seach]

Ben,

There are two parts to the listbox:

1. The RowSource property connects the listbox to data will display in the
list portion.

2. The ControlSource tells the listbox which field to get its current value
from and which field to save its value to. The ControlSource refers to a
field in the table/query on which the form is based.

Graham R Seach
Microsoft Access MCP, MVP
Sydney, Australia