combo box not refreshing in VB

sound_wave · 02-02-2004 11:16AM #1

hi all,
im having this problem with a combobox in my VB app in that it wont refresh when i delete a record from the database. For example, the combo box holds a list of Identification numbers. when i delete a whole record in the db the deleted id number still appears in the combo box. any ideas how i can refresh the combobox after the deletion code?

thanks

mr_angry · 02-02-2004 11:45AM

Right after the deletion code, try the following:

myCombo.requery()

That should probably sort it.

The Corinthian · 02-02-2004 11:56AM

Originally posted by mr_angry
myCombo.requery()

Or in VB you might try Combo1.Refresh instead...

egan007 · 02-02-2004 12:01PM

just call the piece of code that populates your combobox after deletion

The Corinthian · 02-02-2004 12:08PM

Originally posted by egan007
just call the piece of code that populates your combobox after deletion

You're assuming he's not using the VB data control.

egan007 · 02-02-2004 12:14PM

i assume no one uses that - it's the most unflexable ever!!

The Corinthian · 02-02-2004 12:32PM

Originally posted by egan007
i assume no one uses that - it's the most unflexable ever!!

True, but newbies often use it until they know better.

mr_angry · 02-02-2004 12:43PM

Originally posted by The Corinthian
Or in VB you might try Combo1.Refresh instead...

Dammit - too much VBA in my head. I've almost forgotten all the benefits of VB6!

sound_wave · 02-02-2004 12:45PM

thanks lads.

combo box not refreshing in VB

Comments