Hyperlink to another form in your DB?

[manningfan]

Has anyone used hyperlinks to open forms in Access?

I need to write a report (displayed as a form) that will allow users to
click on an item number to drill down further into the underlying data.


I'll need to have the hyperlinks create themselves dynamically in order
to do this. The resulting form will need to send the value of the
hyperlink to a query in order to filter the data further.

Anyone ever done anything like this? I know how to do it using ASP but
I've never done it entirely in Access. Any help would be appreciated.

 

[steve]

Sorry, you cannot use this feature in micorosoft Access 2003... you must
upgrade to microsoft acces 2004.

HTH

Steve

 

[Ron2006]

You can use a <dbl-click> event on a field to open another form and
pass the criteria from this form to the other form.

It would be coded exactly as if it were a button. I do it all the time
to keep drilling down for more detailed information.

Ron