|
Subject:
|
Access 2000 Text not refreshing in combo box
|
|
Posted By:
|
mkjo99
|
Post Date:
|
10/11/2004 11:52:02 AM
|
In the details of my main form, I have a 2 column combo box with the first column (hidden) bound to UnitID. When the form opens, the 2nd column, UnitDescription displays normally. In the OnEnter event of the combo box, I set its rowsource using a sql statement that creates a subset of items based on the contents of another field in the same row. Once I cause this event to fire in any row and then minimize the form or move another window over the top of any of the fields in that column, the text in the combo box(s) that was not visible is erased. If I force a refresh from code then all of the visible text in that column is gone. If I view the drop down list, all of the items I expect to see are there. If I select something from the list, then that item is correctly displayed and is not erased. Any ideas?
|
|
Reply By:
|
jemacc
|
Reply Date:
|
10/11/2004 9:48:06 PM
|
It is possible you may need to refresh the combo box
Try adding Requery to view the latest records in a combo box called UnitID, add the following method to the procedure: unitid.requery
Jaime E. Maccou
Applications Analyst
|
|
