Refresh a combobox

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ray - 30 Jun 2007 15:34 GMT

Can you tell me how to refresh the values in a combobox only, using an event
procedure for the On Current event for the form itself? I do not want to
requery or refresh the whole form, just the combobox.

Reply to this Message

Maurice - 30 Jun 2007 15:56 GMT

try: me.combobox.requery

this will only requery the combobox. replace combobox with your controlname
for the combo.

hth

Signature

Maurice Ausum

> Can you tell me how to refresh the values in a combobox only, using an event
> procedure for the On Current event for the form itself? I do not want to
> requery or refresh the whole form, just the combobox.

Reply to this Message

Ray - 30 Jun 2007 16:06 GMT

Perfect. Many thaks

> try: me.combobox.requery
>
[quoted text clipped - 6 lines]
> > procedure for the On Current event for the form itself? I do not want to
> > requery or refresh the whole form, just the combobox.

Reply to this Message