Refreshing a combo box based upon a database file w/o exiting the

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I created a combo box on a form based upon a query over the employee master
file, listing the employee number and employee name. The employee number
updates a field in the Continuing Education Detail file.

The problem I am having is when they are working on entering the continuing
education detail and come across a new employee. It happens quite often.
They open the employee master file form and enter the new employee, but it
does not come up in the combo box to choose it in the continuing education
detail form without closing out of both the employee master file form (even
though the record has been saved to the employee master file) and continuing
education detail form and reopening the continuing education form.

Is there a way that the combo box can be refreshed each time it is chosen on
the field in the continuing education detail subform without having to exit
and reopen both forms?

I have looked in my books and can not find the answer.
.

Relevant Pages