I have a main form that list all the records and on click opens the detail of a given record via a Modal window form. Through the wizard I've added a delete record button that additionally closes the modal form and returns to the (still opened) form list. I want the main list to be refreshed/requeried when the form is closed, as I see #Deleted.
I'd rather not do some work-around where the form is closed and opened again to get the same result. How would I go about doing it? I am new to VBA, so I can follow code as long as it comes with a little hand-holding. Any help would be appreciated.
Thanks.