update combobox

I have a start up (or autoexec) form with a combo box which lists the
clients' names (I need it for a parameter query). These names are entered in
another form, which starts with a control button in the same startup form,
and then are sorted in the query "clients_list".

The combobox of the startup form is not updated unless I rerun it. I would
like to keep the startup form always "on top", add my clients and to all the
other operations, and have the combo box updated without restarting the
form. Is it possible to do so?

Thanks in advance.
Beppe

Beppe,

I think it will achieve your purpose to put code like this...
Me.NameOfYourCombobox.Requery
.... on the Enter event of the combobox.

--
Steve Schapel, Microsoft Access MVP


beppe005 wrote:
I have a start up (or autoexec) form with a combo box which lists the
clients' names (I need it for a parameter query). These names are entered in
another form, which starts with a control button in the same startup form,
and then are sorted in the query "clients_list".

The combobox of the startup form is not updated unless I rerun it. I would
like to keep the startup form always "on top", add my clients and to all the
other operations, and have the combo box updated without restarting the
form. Is it possible to do so?

Thanks in advance.
Beppe