Search function returning zero results on 2nd use

[Rkelly101]

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.

 

[The_Doc_Man]

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" ??)