Item: Access app front end for an SQL database (production tracking/job logging utility)

Problem: The app has a main search page that allows job entries to be located and opened by varies criteria (job#, job name, etc). I can currently run multiple searches on different criteria successfully but if I open a job window(which has been returned as result of my search) and then close that job window to do a new search my search function will no longer return any results(other then “Calculating….”) unless I close out the access app and reload.

Thanks in advance for any ideas that can point me in the right direction to hunt down my bug.

Probably an example of an "Old programmer's rule" in action.

If any intermediate variables are used to implement this function, reset them between activations. The act of closing and re-opening the form sounds to me like a de-instantiation, re-instantiation. Which means you need to clean up after yourself.

The OP rule: If you open it, close it. If you make a mess, clean it up. If you take it out, put it back. (What was that book with a title like "Everything I need to know I learned in kindergarten" ??)