I have just started creating an Access 97 db that will serve as a "question response center." A user can log in and enter information to ask the experts. This will log the question in a table and send an email to the expert group.

I would like the expert to be able to click a link or shortcut in the email that would bring them to a response form and enter the answer. I would then obviously send this response to the person that asked the question.

I want to keep the questions and responses for historical trending.

The problem is I do not know how to link to a form opened to a specific record.

Any ideas out there?