Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Combo box losing values after edit

Status
Not open for further replies.

StephDN

MIS
Nov 13, 2001
8
US
I have created a form to pull in existing data to be used for editing. Users select the date of the information they wish to edit, then the form loads with all information for that particular data. They use buttons to navigate to the next record to edit - fairly simple. The problem: after editing two or more records, the combo boxes are losing values?!? They need to restart the whole program in order to restore the values in the dropdown lists. I don't know what could be causing this to happen. Any advice is VERY much appreciated. Thanks in advance!
 
Sorry for the ambigious answer but!

look at the rowsource of your combo boxes. Is it based on data that is being filtered down.

Or you could try me.refresh based on some event to reset the combo boxes.
 
Does the Combobox turn out blank? Is that the data the the user enters to edit the data? If you say that they are losing their values after a couple of records changes, then I think that that record does not have any value for that control. What is your rowsource? Please elaborate more. "The greatest risk, is not taking one."
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top