update one form based on another

[mpmason14]

i want to update my "timesheet" form based upon a second form "add employee" whenever a new employee is added. right now the "add employee" form adds the employee to the table, but it doesn't update the form to show the new employee unless i close the "timesheet" form and reopen it.

any ideas how to get the "timesheet" form to automatically update with the new records when i close the "add employee" form?

thanks

[PEB]

i want to update my "timesheet" form based upon a second form "add employee" whenever a new employee is added. right now the "add employee" form adds the employee to the table, but it doesn't update the form to show the new employee unless i close the "timesheet" form and reopen it.

any ideas how to get the "timesheet" form to automatically update with the new records when i close the "add employee" form?

thanks

Hi,
You need to requery your updated form...

You can do it using on after update event int Add employee control:

Forms!timesheet.Requery

Have a nice day!

:)