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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Form Refresh 1
Form with Subform not Refreshing 1
Separate Form 0
Refresh a form 3
First Subform record gets modified when closing form 3
Refresh Subform query 2
Update / Refresh as sub form 1
Flashing screen 3

Back
Top