Links in Query results

[shm135]

Hi,

Here is the scenario I am hoping to accomplish:

I have two tables, each with an autonumber field. I've included these
autonumbers in multiple queries, so that I can reference these
specific records in their respective tables. I would like to be able
to click on the autonumber in any query and have it open the table and
filter down to that autonumber.

Is this possible? Can somebody please guide me?

Thanks,
Sam

 

[Jeff Boyce]

Queries, as far as I know, don't "drill down". Perhaps you can find an
Active X control that does so, searching on-line.

Regards

Jeff Boyce
Microsoft Access MVP

 

[Jerry Whittle]

Queries do not have events which would open another table.

You might be able to make it happen with a form in datasheet view using the
On Click event of the field.

 

[shm135]

Queries do not have events which would open another table.

You might be able to make it happen with a form in datasheet view using the
On Click event of the field.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.









- Show quoted text -

Thanks for the suggestions. I will try to figure out how to do that!
Thanks again.