Updating table with form

[Joyce]

I have a form that I pull information in from the employee
tabled based on the employees ID. The employee ID is a
dropdown, so when the correct ID is clicked, all the
necessary data prefills onto the form. We just hired a
large amount of new employees so rather than keying all
their info into the table, I want to be able to update the
employee table when new requests are made. Currently the
Employee ID field only allows the selection of current
employees. What do I do to open that up to new employee
ID's and to also save that data into the employee table.

I appriciate your help, thank you

 

[Kevin Sprinkel]

You can use the On NotInList event to open up your
Employees form to add the new record. When you return,
you will need to requery the combo box to have access to
the new record's PK.

Be sure the combo box' Limit to List property is set to
Yes to trigger the event.

HTH
Kevin Sprinkel