combo-box drop down list not updating

[mark kubicki]

I have a combo box whose drop-down list of values should be the current list
of all of the unique values that have thus far been entered into that field
(the control source field for the combo box is the same as the list of the
drop-down)
- the row source is set as the control source field with its query's unique
value property set to be true.

the conflict is:
the list does not update until the form (table?) is closed; when it is
reopened, it is current.

I need the list to be volatile, and constantly updated as new entries are
added...
suggestions?


thanks in advance,
mark

 

[Rick Brandt]

I have a combo box whose drop-down list of values should be the
current list of all of the unique values that have thus far been
entered into that field (the control source field for the combo box
is the same as the list of the drop-down)
- the row source is set as the control source field with its query's
unique value property set to be true.

the conflict is:
the list does not update until the form (table?) is closed; when it is
reopened, it is current.

I need the list to be volatile, and constantly updated as new entries
are added...
suggestions?

In the AfterInsert event of the form have code...

Me!ComboBoxName.Requery