A few questions
First, how can I program a form button to open a specific attachment? I want the button on click to go to an table and open a specific attachment.
Second, why I was thinking about this. I want to include a button on my form to open an explanation or guide for the form. I thought about opening another form or report, but then thought about having this guide in pdf format. So I would have a table called tblGuides which would consist of a autonumber field, description text field and and an attachment field. The "Form Guide" button on my form frmLeasing would open the Leasing Form Guide, presumably by finding the autonumber.
Let me know if this makes sense at all, or if I am barking up the wrong tree.