Combo Box Requery

[isorders]

I can't seem to get a combo box to refresh after the value in it is changed. Its a not limited to list combo box, so when the user changes something I want the list to update.
I have tried onchange, on lost focus, on not in list, etc with no good solution.

 

[JonoB]

Are the changes actually being made in the combobox, or elsewhere on the form?

And what command are you actually trying to use?

You could try docmd.requery on the afterupdate event for whichever control you are updating from. This will requery all controls on the form.

 

[isorders]

The changes are being made in the combo box.
Field: Name
Lists of Names:
Bob
Frank
Jill
Sam
If Sam is selected and I want to change it to Sammy, I want Sammy to appear in the combo box list.

 

[JonoB]

How do you actually make the change to the name? I stand corrected on this, but I's pretty sure that you cant easily make changes to a record directly in the combobox.

I suggest that changes are made through another control, such as a textbox, that is linked to the combobox. You can requery the combobox on the afterupate event of the textbox (ComboBoxName. Requery), or after u click an 'update' button for example.

Hope this helps.

 

[fneily]

On the AfterInsert event of the FORM, put:

Me![Comboboxname].Requery

Neil