Events for Queries?

[Nick34]

Are there any ways to add VBA code to a query event? For instance, when I open the query, run the code.

 

[seaport]

You may put a VBA function in the query. Then this function runs every time you run the query.

for example,
***
select customername, FireTheEvent() from tblCustomers
***

seaport

 

[Nick34]

Ok. I want this function, Unit130Day(), to run when I open the query. So where do I tell the query to do this?