Updating Form Open Or Closed

[kevsim]

I have 2 forms, one accessed by password for entering data, the other for data searching and is for general use.
When I update the input form with new data and the search form is closed, when I open this form the data is there.
Should I input data while the search form is open, this form does not update.
What code do I need to update the search form in both circumstances?
I would appreciate your advise.
kevsim

 

[Pat Hartman]

When working with multiple objects that may be viewing the same record, you need to make sure that you force Access to update the current record before you switch from an update form to a related form or report. You may also need to requery the recordsource of the related form or report if they are open. To save the current record, create a Save button. The code behind the button click event is:

DoCmd.RunCommand acCmdSaveRecord

If your code, opens the related form or report, you won't need the extra step of a save button, just place the save command in the ButtonClick event ahead of the OpenForm or OpenReport statement.