I have created a query that uses the circuit ID as the trigger to show what channels are vacant. I created a macro that will launch the query and display the results. This does work, but the only problem is that it never closes. The only way it closes is if you close the leading window. Originally i just wanted a pop up window that listed the vacanies. I have a query that will display it. I have it set to run as a macro, I also tried doing the stop macro command on lost focus or even click on anything else, all it did was crash my database.
I do not know if there is a way to get a window to disply a query result if you hover your mouse on the field that would trigger the event is there? If not thats ok, I can set it to a click event, but how can I get the query result window to close so another circuit can be "checked" for vacancies?
I do not know if there is a way to get a window to disply a query result if you hover your mouse on the field that would trigger the event is there? If not thats ok, I can set it to a click event, but how can I get the query result window to close so another circuit can be "checked" for vacancies?
