Refresh Form

  • Thread starter Thread starter Daniel
  • Start date Start date
D

Daniel

Hello All,

I have a Main form that has a command button to open another form to enter
data into a linked table Problems (One to Many). The records in the linked
table Problems are displayed in a subform on the Main form. When the
records from Problems are modified, deleted, and the form is closed, the
records showing on the subform are not updated, or refreshed. I have tried
to refresh the form, but can only do it manually. I need to know how to
refresh the main form automatically when the second form is closed, or after
a record has been updated on the second form. I have tried the lostfocus,
and gotfocus properties, but no luck. Can anyone help?

Thanks,

Daniel
 
I found the answer, I thought I had tried it, but guess I didn't.

In my code on the second form:
Problems_Close
Forms!Main.Requery

Worked.

Daniel
 
Back
Top