Access 2002 Form Problem - Help!

[John Lane]

I have a subform with a combo box on a tab that opens a
small form. When the small form closes, it “wipes out”
part of the displayed data in the underlying combo box
control. I tried Repaint and it does nothing, and Requery.
The Requery executes and displays no data. Closing and
opening the main forms clears it up, but is painfully
slow. Has anyone run into this? Is there a fix?

 

[Rowland]

here is a shot in the dark here, and it may be as slow as
reopening the form, but I don't think so.

try a me.requery on the subform only.
that way it wont be the same as re opening the whole
form, but perhaps you already tried that.