I have a subform on my form which displays a query as the source object. I did this to accomodate the dynamic nature of the fields within the query (it's a crosstab query which has different numbers of columns based upon the results the user is after).
I want to have the user double click a field on the subform query (an order number) and have another form open (trigger an event).
Is this possible?
Thanks in advance.