Refreshing combo box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

medirate - 01 Apr 2008 17:16 GMT

I have a combo box which allows the user to select an employee. The employee
and his record are then displayed using a main form and a subform.

The problem is that I also allow the user to scroll through the employee
record using the record selectors. So the record might be on Jane Adams
while the combo box still shows John Smith. As a result, I've noticed the
wrong information being placed in the record.

How can I get the combo box to refresh its display with the main form's
record source, or alternately can you tell me how to clear the combo box
once a user has made a selection?

Reply to this Message

M Skabialka - 01 Apr 2008 17:02 GMT

In the after update code for your combo, to clear the combo, place something
like this:
me!mycombobox = ""
or
forms!myform!mycombobox = null

Or in the On Current event for the form, to show the current record,
something like one of these:
forms!myform!mycombobox = forms!myform!employeename
me!mycombobox = me!employeename
mycombobox = employeename
Mich

>I have a combo box which allows the user to select an employee. The
>employee
[quoted text clipped - 8 lines]
> record source, or alternately can you tell me how to clear the combo box
> once a user has made a selection?

Reply to this Message

Klatuu - 01 Apr 2008 21:31 GMT

If the intent of the combo is to look up employees, it should not be a bound
control.
The employee name field should be bound to a text box and the combo should
be used only for locating an employee record.

Signature

Dave Hargis, Microsoft Access MVP

> I have a combo box which allows the user to select an employee. The employee
> and his record are then displayed using a main form and a subform.
[quoted text clipped - 7 lines]
> record source, or alternately can you tell me how to clear the combo box
> once a user has made a selection?

Reply to this Message