Auto refresh new data insert

Question

hi,

i'm currently working on a project with multiple inserting and removing of data from a table. 

currently i have two forms - formInsert and formDelete

For formInsert, its pretty standard, i used the wizard "add existing fields" and button to "add records". Now the problem with that is the data that was inserted is not refreshed automatically into the table.

Therefore making my formDelete redundant as it is not able to retrieve the newly inserted data as it is not refreshed automatically..

So is there an actual way to go around this?

thanks. 

Answer 1

Hello syahid noor,

After adding records, try to refresh formDelete form.

If CurrentProject.AllForms("formDelete").IsLoaded Then
Forms!formDelete.Refresh
End If

Best Regards,

Terry

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 2

I think you want to .Request, not Refresh the form.

---

Daniel Pineault, 2010-2017 Microsoft MVP
Professional Support: http://www.cardaconsultants.com
MS Access Tips and Code Samples: http://www.devhut.net

Answer 3

?Request?  That is not a method of the form object. Did you mean to say Requery?

---

-Tom. Microsoft Access MVP