Is there a way to open and access form from a link?
Posted on 2011-02-24
Is there a way that I can open a specific form and find a specific record in my Access application from a link that can be embeded in an email?
Here's the application: We send quotes to our customers to follow up on orders. When the customer replys, we must manually look up the customer's quote number in our Access database to locate the quote in our database.
I'm hoping there is a way that I can click on a link in the email that will open up our quote form and locate the proper quote.
If this is not possible, I'm open to other ideas.
Just for reference, lets say the name of the form is frmQuote and the recordsource would have to be "Select * from Quotes WHERE QuoteNumber=12345"