P Peter Morris Sep 10, 2005 #1 what's the VB instruction to redraw a listbox after I've changed the SQL in the row source?
D Debra Farnham Sep 10, 2005 #3 I think what you're looking for is me.nameoflistbox.requery but it will need to be attached to an event - maybe a command button or at the end of the event that is changing the SQL? HTH Debra
I think what you're looking for is me.nameoflistbox.requery but it will need to be attached to an event - maybe a command button or at the end of the event that is changing the SQL? HTH Debra
P Peter Morris Sep 10, 2005 #4 Debra Farnham said: I think what you're looking for is me.nameoflistbox.requery Click to expand... Thanks to both you & PCD. but it will need to be attached to an event - maybe a command button or at the end of the event that is changing the SQL? Click to expand... Yeah, its one part of code that runs when I click another conrol.. HTH Click to expand... it did
Debra Farnham said: I think what you're looking for is me.nameoflistbox.requery Click to expand... Thanks to both you & PCD. but it will need to be attached to an event - maybe a command button or at the end of the event that is changing the SQL? Click to expand... Yeah, its one part of code that runs when I click another conrol.. HTH Click to expand... it did
