none
Auto refresh new data insert RRS feed

  • 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. 

    Tuesday, May 15, 2018 5:24 AM

Answers

  • 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 MSDNFSF@microsoft.com.

    • Marked as answer by syahid noor Wednesday, May 23, 2018 4:47 AM
    Tuesday, May 15, 2018 8:29 AM

All replies

  • 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 MSDNFSF@microsoft.com.

    • Marked as answer by syahid noor Wednesday, May 23, 2018 4:47 AM
    Tuesday, May 15, 2018 8:29 AM
  • 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

    Tuesday, May 15, 2018 1:42 PM
  • ?Request?  That is not a method of the form object. Did you mean to say Requery?

    -Tom. Microsoft Access MVP

    Tuesday, May 15, 2018 1:53 PM