I have a form that displays the most recent records in order to assist the user entering data to help keep from double entering data. However, currently the query data that is displayed doesn't update until you close the form and reopen it.
I am wondering how to get the query results to update when a new record is entered on this same form. I have tried but usingHowever, when I run this sub using the AfterUpdate event it comes back with an error. I think it is because the control source I am trying to use is not on the main form and is on the subform I need to update.Code:Me.[ControlSource].Requery
Any suggestions?