Richard,

When following the updated code builder steps to create the Private Sub, it does work, but only the first time I try to access the form.  For instance, after setting the OpenLocation subroutine (11:30) and updating the other two subs, I save the code and exit code builder.  Close the customer form, and then reopen.  Double Click or Button Click to open store works 1 time.  If I close the Location Form and attempt again, I get a Run-Time Error 3008.  It indicates that the Table Location_T is already opened exclusively by another user or it is already open through the user interface and cannot be manipulated programmatically.  Upon clicking Debug, I am brought to the code builder and the "DoCMD.OpenForm ..." is highlighted in yellow.  My code reads as follows:
DoCmd.OpenForm "Store_F", , , "SKEY_STORE_CURR=" & Reporting_List

How can I get around this issue so that end users can close the location form and still be able to use the code to access new stores from various customer profiles?

---

Reply from Richard Rost:

I've never encountered this before, and no other students have reported this problem. What version of Access are you working with, and do you have all of the latest service packs installed? Bug like this were notorious in Access 2007 (especially before SP1). Can you recreate the problem with a different form? Have you tried rebuilding the form in a new, blank database? This is one of those things that I really have to SEE to fix.