Don_S
Posts: 50
|
| Posted: 05/23/2005, 3:18 PM |
|
I have a form with 2 list boxes. Both us ListofValues forthe data source. With identical settings (other than control source and the actual values) one works and the other does not... Both are text values. If I change the values in the one that does not work to numbers instead of text then it will populate the field, other wise it leaves it blank. example:
Value/Discription:
Coin/Coin
Paper/Paper
Does not work
1/Coin
2/Paper
Does work
any ideas? this is drivingme crazy!
Don
|
 |
 |
peterr
Posts: 5971
|
| Posted: 05/23/2005, 3:27 PM |
|
This looks OK to me and this is how it must work if the listbox is bound to a numeric field in the database.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
 |
Don_S
Posts: 50
|
| Posted: 05/24/2005, 8:05 AM |
|
Actually it had nothing to do with the database or the input form... my text box in the table viewing the data was set up wrong, interger instead of text... oops! LOL
Just go to show that you have to check everything!
Don
|
 |
 |
|