Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Fri Sep 24 11:13:46 CDT 2004
Dear List: Sorry for the undescriptive subject but I don't know how else to say it. Client is at a remote site running an app I created for them. App is created in Access 2000. It's running on Access 2002. In this app, which tracks assets, the hierarchy is Cluster, Buildings within Cluster, Rooms within Buildings. There is a query qryBuildingByCluster that is the row source of a combo box on frmRoom. The uses Forms!frmRoom!txtClusterID as a parameter and the combo box is requeried every time a room record is displayed so that the combo box will display only buildings in the selected cluster. All's well and good. It runs fine on every box its ever been on. But on this one box, when the user exits from frmRoom and the Main Menu is displayed, they get an "Enter Parameter" box prompting for Forms!frmRoom!txtClusterID as if the combo box is being requeried. But at this point the form frmRoom is closed. I've stepped through the code and the parameter prompt appears AFTER the .Close. qryBuildingByCluster is only used in one place in the system - as the row source of the Building combo box in frmRoom. We checked references and they're identical to the client's laptop on which the program runs fine - can't duplicate the error. Has anyone ever seen this behavior before? MTIA Rocky Smolin Beach Access Software http://www.e-z-mrp.com