update combobox

B

beppe005

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
 
S

Steve Schapel

Beppe,

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automation of scanned file storage based on content 0
Style Gallery View 3
Update Combobox 2
Update a an unbound combo box 1
Combobox 1
comboboxes 3
Data entry VBA 1
Data entry to table from a form 0

Top