I have a report that shows monthly expenses by vendor. Is it possible to click on a vendor name from the report and have it hyperlink to a query that will show more detail of that vendor? Thanks for your help in advance!
Novice
Windows XP 
Access 2003
I have a report that shows monthly expenses by vendor. Is it possible to click on a vendor name from the report and have it hyperlink to a query that will show more detail of that vendor? Thanks for your help in advance!
VIP
Windows XP Access 2010 32bit
This is not hyperlink, this would be using code in textbox Click event to open an object (query, form, report) with:
DoCmd.OpenReport "reportname", , , "VendorID=" & Me!VendorID
DoCmd.OpenForm "formname", , , "VendorID=" & Me!VendorID
DoCmd.OpenQuery "queryname"
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Where is the hyperlink....
Hyperlink Help
Posting Permissions
Reply With Quote