Updating open Form when new information is added to a table.

[Moltin]

Hello everyone.



I'm lost on how to update a form without closing and re-opening it.

Here is my situation: I have a navigation form that displays information about each of my employees individually by selecting a name from a scroll box. I have a button that opens up a new form allowing me to Add New Employees. The problem is once i have added my new employee and close that 2nd form i'm staring back at my first Employee form although when i select the scroll box i can not find that new employee to view. the only way around this is to close the form and re-open it. Is there a macro i can add to the scroll box or form to auto update without having to close and re-open?

thank you for your help

[Micron]

If the combo is a bound field, in the close event for the adding form, try Forms!frmFirstForm.Requery.
If it is not, you'll have to drill down to the actual control: Forms!frmFirstForm.cmbComboboxName.Requery
Sub in your actual object names.
You may want to ensure that the first form is still open, otherwise an error will occur when trying to requery a form that is not open.

If CurrentProject.Allforms("frmFirstForm").Isloaded Then
   Forms!frmFirstForm.Requery
End If

[Moltin]

Thank you micron, I'm still learning so I will give this a try tomorrow, I appreciate the help.