Refreshing combo box

  • Thread starter Thread starter M Skabialka
  • Start date Start date
M

M Skabialka

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
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?
 
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.
 
Back
Top