Data Captured in List Box not populating tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list box that is pulling data from a row source just fine. It shows
up fine on the screen, but will not populate to the control source field
properly. Does the fact that my row source information is pulling an
autonumber field part of the issue? Other list boxes on the same form are
populating data just fine, but this one won't. Any ideas?
 
The Control Source property of the list box defines which field it is to
write its data to.

This field must be of the same data type as the Bound Column of the list
box. For example, if you are trying to write a Number that is not visible in
the listbox, it would normally have these properties:
Bound Column 1
Column Count 2
Column Widths 0
RowSource SELECT MyID, MyText FROM MyLookupTable;
Control Source MyNumberFieldInMyOtherTable
 
I have a list box that is pulling data from a row source just fine. It shows
up fine on the screen, but will not populate to the control source field
properly. Does the fact that my row source information is pulling an
autonumber field part of the issue? Other list boxes on the same form are
populating data just fine, but this one won't. Any ideas?
Click to expand...

You don't have it set to MultiSelect do you? With MultiSelect enabled the
ListBox will always have a value of Null and cannot be used as a bound
control.
 
Back
Top