I have a form with an Add button and right after pressing add I want to insert a record to my db (no problem there), close the form and return to, plus run a requery on, the previous form which should show the new record I just added in its list.
First problem: I can't close the form. I thought this would be something as simple as docmd.close but I think that was actually closing the previous form.
To refresh the data on the previous form, is that just a requery and is this syntax correct: Forms![History Filter General].Requery and are there rules where I can call that instruction from?
Tip - closing the form should be the last command. Do whatever is needed first that is reliant of that particular form i.e. open a report or query etc and then close the form using the form name. If you want to reuse the information from a dialogue box open it in a hidden state and open it again in the usual way.