Macro in a field of a table?

[mjchristinaj]

Hi,

I would like one of the fields in my table to be a link that when I click runs a macro (a query). So, if the field is called 'Keywords', the entry has a keyword (for example "products"), and when i click on it, I get the result of a certain query (for example, the query that shows the "products" from a different table). How can I do that?

thank you!

 

[pbaldy]

I don't think you can do it at the table level, but you could code the click or double click event of a text box on a form to do whatever it is you want.