combo-box drop down list not updating

  • Thread starter Thread starter mark kubicki
  • Start date Start date
M

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
 
mark said:
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?
Click to expand...

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

Me!ComboBoxName.Requery
 
Back
Top