I have a large form with a lot of code and a tab control. When the user is on tab two and uses the close button that I put at the bottom of the screen the following message box pops up - Enter Parameter Value for forms!caseDetails!BuyerMortgageCompanyID. If you enter a value nothing happens - it just closes the form.
I have checked everywhere possible for what event is initiating the query but cannot find it. If I click the close button "X" in the upper right of screen the query is not activated which is very confusing. I have tried commenting out large blocks of code and eventually am able to get rid of the problem but why does it run the query when the close button (added to the bottom of screen) is clicked but not on the form close button (upper right).
I would just scrap the form but it is huge and would take days to reconstruct. Any help troubleshooting would be appreciated. Thanks.
I have checked everywhere possible for what event is initiating the query but cannot find it. If I click the close button "X" in the upper right of screen the query is not activated which is very confusing. I have tried commenting out large blocks of code and eventually am able to get rid of the problem but why does it run the query when the close button (added to the bottom of screen) is clicked but not on the form close button (upper right).
I would just scrap the form but it is huge and would take days to reconstruct. Any help troubleshooting would be appreciated. Thanks.