Update a combobox

A

alvin Kuiper

Hi
Have a combobox there takes the value from a table
in the same form i have a Commandbutton there open another form
to write a new value in the same table, now i want to have my
combobox to refresh (update) so the new value i just write
is there, off course i can close and open my form But is there
not a better way to update this field


Alvin
 
S

Stefan Hoffmann

hi Alvin,

alvin said:
Have a combobox there takes the value from a table
in the same form i have a Commandbutton there open another form
to write a new value in the same table, now i want to have my
combobox to refresh (update) so the new value i just write
is there, off course i can close and open my form But is there
not a better way to update this field
Use
DoCmd.OpenForm FormName := "YourForm", WindowMode := acDialog
ComboBox.Requery


mfG
--> stefan <--
 
Top