Hello, I have a form with a subform. I have a function where I double click on a record in the subform and this opens a pop up editable form.
I want the subform to refresh after changes have been made on the pop up form.
At the moment I just have a 'save and close' button on the pop up form which returns to the form with the subform, but the subform isn't being refreshed with the new data. How do I get this to happen?
I have tried entering the code
Me!Subform.Requery but MS Access says it can't find the referenced form or that the form is closed (which is actually isn't).
Any answers?
Thanks
I want the subform to refresh after changes have been made on the pop up form.
At the moment I just have a 'save and close' button on the pop up form which returns to the form with the subform, but the subform isn't being refreshed with the new data. How do I get this to happen?
I have tried entering the code
Me!Subform.Requery but MS Access says it can't find the referenced form or that the form is closed (which is actually isn't).
Any answers?
Thanks