LanaR
Member
- Local time
- Today, 18:07
- Joined
- May 20, 2021
- Messages
- 113
In a long-term DB, I have a search from that had been working flawlessly. However, when I opened the DB this morning and tried loading the form I got a series of "Enter Parameter Value" dialogue boxes (relating to controls on the form) culminating in an "Error 3 Return without GoSub!", then when the form does open it has all sorts of errors.
Now if I open the form in design view and place a Break Point in either the On Load or On Current event(s) and step through the code or simply resume the code, the form returns to working as expected. I can then remove the break point and close and open the form as much as I like without an issue. If however I close and re-start the DB the aberrant behaviour returns until I once again go through the procedure of placing a break point in the code, then removing once the code has run once.
A little background, we did have a power outage last night and this behaviour has appeared since then. I am currently at a loss to figure out what is causing this behaviour and how to rectify it
Now if I open the form in design view and place a Break Point in either the On Load or On Current event(s) and step through the code or simply resume the code, the form returns to working as expected. I can then remove the break point and close and open the form as much as I like without an issue. If however I close and re-start the DB the aberrant behaviour returns until I once again go through the procedure of placing a break point in the code, then removing once the code has run once.
A little background, we did have a power outage last night and this behaviour has appeared since then. I am currently at a loss to figure out what is causing this behaviour and how to rectify it