Search tool shuts down Access

[rbrule]

Hello,

I have a form with two subforms. The subforms are created from two queries. When I search the main form, Access shuts down after two searches, with no error message. It did the same thing when the subforms were based on tables. Does anyone know why this happens, and what the fix is?

 

[MarkK]

When I get weird stuff like that happening I decompile the file, and then do a compact and repair.
To decompile, close the file, goto windows "Run...", and type in this info...

"<path to MSAccess.EXE>" "<path to Your.MDB>" /decompile

You can also put that in a shortcut in case it works and you need it in the future. But that will open your file and rebuild all your code from scratch.
To compact & repair, AccessMenu->Tools->DatabaseUtilities...

 

[rbrule]

Thank you I'll try it