Update combo box

  • Thread starter Thread starter bob e
  • Start date Start date
B

bob e

Is there a way to update/refresh a combo box list without
closing and reopening the form? If I don't see the item
in the combo box, I click on a command button that opens
a form. That form allows me to enter new records that
populate the combo box. But it doesn't make that addition
appear in the combo box untill I "reboot" the form. can I
do a refresh command button with a macro, if so how??? Or
is there another low-code approach, since I'm awefull
with codeing. Otherwise I need someone to hold my hand
and walk me thru.
 
I feel like an idiot... I was thumbing thru microsoft's
poor "Help" system, Hit the F-9 key to update comobox
lists or listbox lists. Works like a charm. Wish they
hadn't tried to keep it such a secret...
 
bob e said:
I feel like an idiot... I was thumbing thru microsoft's
poor "Help" system, Hit the F-9 key to update comobox
lists or listbox lists. Works like a charm. Wish they
hadn't tried to keep it such a secret...
Click to expand...

For the improved, automatic version,

Me![comboboxname].Requery

when you are done updating. Never leave something simple to a user ... as
soon as you idiot-proof a system, along comes a new and improved version of
the idiot ...
 
Back
Top