combo box not refreshing in VB

sound_wave

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

Right after the deletion code, try the following:

myCombo.requery()

That should probably sort it.

The Corinthian

Originally posted by mr_angry
myCombo.requery()

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

egan007

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

The Corinthian

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

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

The Corinthian

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

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

thanks lads.