Running a macro automatically when accessing a predefined query?

[lieip]

How do I call run a macro as soon as I access a query?
I'm creating a database in access and also creating a web interface... now my problem is that i need to run a macro when i access a query that i've already defined in the Access database.. how can i do that without having to create a button with code behind it to run the macro.

any help would be greatly appreciated!

 

[Eldaria]

As far as i know you can not run Macros from a Query, as it does not have any events, you would probably have to do it the other way around, run the query from the macro.

So this way all you need to perfrom via the macro will be perfromed before or after you run the query...
Eldaria

http://www.eldaria.net

That was my 25cent** of opinion.

** Inclusive Intrest, tax on interest, Genral tax, Enviromental tax, Tax, and tax on intrest, tax on fees, tax on tax, and other Various taxes and fees.

 

[lieip]

Can I use VBScript to run a macro? i know that you can run a macro when you create a button on a form... but if i was to create a button using vbscript or javascript can I program the button to run the macro?