DBListbox

[Guest_imported]

I populated a DBListbox (U.S. States), at design time for user input. This is not a required field therefore not all records will have a state listed. I left the first Item in the DBListbox blank. I use a DBNavigation control to scroll through the records on a user input form. If the first record has a state listed (OH), and the second does not, the (OH) remains in the DBListBox on the second record. This should be blank because the database field does not have a value. Why does the DBListBox not change to reflect the actual value in the database field? The DBListBox field does not change until a different state is encountered in the database, (WI) for instance. Then if the next database state field is blank, (WI) is still displayed instead of a blank DBListbox. Can someone help me with this?

 

[Svanhooft]

hi,

Just add a blank line to the items of the dblistbox.

Steph [BigGlasses]

 

[Guest_imported]

I have placed a blank line at the begining of the list items. The problem is that when I scroll through the records on the form, if the field in the database is blank the DBListbox on the form does not update this info on the form. It displays what was previously in the box.