Links in Query results

  • Thread starter Thread starter shm135
  • Start date Start date
S

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
 
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
 
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.
 
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 -
Click to expand...

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