[AccessD] List box misbehaving

Have you tried setting the listbox's visible property to false when you
make the subform visible?  That is the simplest way to handle it.

Charlotte Foust

-----Original Message-----
From: Don Elliker [mailto:delliker at hotmail.com] 
Sent: Tuesday, June 17, 2003 8:16 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] List box misbehaving


Hi folks,
I have an XP app that is giving me the business. Bound form with a
tabcontrol for various memo fields. A list box with a separate data
source (query of another table related to bound form recordsource) An
invisible subform which is the same data as the mainform but in a more
'Excel-like' display. When they request to see the data as presented by
the invisible form I make it visible (Ta Dah!) It overlays some of the
controls and the listbox is one of them. The listbox refuses to be
overlayed...it floats on top of the subform. I have played with
everything I can think of - including deleting the control and
compacting and repairing, then re-creating the control. It still floats
on top (super-annoying) -I checked for requeries of the listbox. I
checked taborders and remnant code, there are no repaints or restore
commands. 
Interestingly, I cannot get the listbox to 'move to back' nicely...it
flickers but stays on top of the Box it sits on - none of the other
controls act this way. Also, if I maximize the form...it doesn't
misbehave...but that, of course, is NOT the solution......???
Thanks,
_D




"Things are only free to the extent that you don't pay for them".-Don
Elliker 



STOP MORE SPAM with the new MSN 8 and get 2 months FREE*