Tips to improve your MS Access forms, impress users, and save time. Microsoft Access unbound form design and programming examples.
But it bothers me to requery the form unless you know for a fact that records have been added. 5 Free Software To Record Internet Radio there. I expect that if I needed to do this (I've never done so, actually - - my users know about Shift- F9 where it's relevant, but most of them never need it), I'd use the On.
Activate event and check the current count of records and only requery the form if the count doesn't match the current recordset. But again, I consider it a fairly exotic thing to do. In general, it's probably an architectural error to have too many forms sitting around with an open recordset that you depart from and then come back to. They should probably be entirely closed instead of being left open when you're away from them. This reduces the number of table handles, as well as the number of locks held on the back end database, both of which can be problems if not properly managed.
Passing parameters between forms in MS Access. Why not create a public function which stores & /or retrieves a global variable that you store after the first form is executed?