Forms

[txdon32]

I have 4 forms created in my database. I would like my main form to automatically update when information is placed in the other forms (no, they are not subforms). Is there a way to make this happen? Keep in mind, I am a self taught novice, so be gentle.

txdon32

 

[dcx693]

You need to refresh the main form to reflect the changes in the other forms. As long as the recordsource for the main form doesn't change, I believe you don't need to requery it.

Use code like:
Forms("yourMainformname").Refresh

Now, where to put that code? The code needs to be run whenever you need to update the main form. That will happen when a record in your other forms is updated. So use the After Update event of your other forms to refresh the main form.