Hi,

I have been messing around with listboxes as I like them better than subforms.

Anyway, I found a solution back in access 97 and have used it since in 2k and 2003 and it works pretty well. Ok it is somewhat slower at refreshing and displaying, but at least it doesn't hold the tables open.

However, recently I noticed that the listbox appears to be getting refreshed (re drawn/painted) when the mouse is moving over the form... The mouse moves over a label no where near the list box and it refreshs. I checked this by putting a break point in the code (not a goood idea) then via a debug statement. It is also visibly redrawing, but I don't think it is refreshing the data, jsut forcing a redraw.


Has anyone else come across this?
Is there a particular property on the listbox/form that needs to be changed?
Is it just that I have coded it baadly?? (no don't say that!)