Checkbox OnUpdate to upload attachment, OnClick for label to view.

[PeachTosser25]

I have a single table with one record per person.
I have multiple training checkboxes that every person has to check yes, but only if they've completed the training.
On my table, there is a TrainingA Yes/No field and a TrainingA Certificate attachment field.
I want to have the checkbox require a certificate be uploaded to the attachment field to be marked as Yes, and if the label for the checkbox is clicked, the attachment to open (only if uploaded).


I'm pretty good with If/Then VBA, but outside of that I'm still learning.. Just looking for a little help on getting this all to work.

Is this possible?
Thanks in advance.

[June7]

Google: Access VBA open attachment

Is this what you want http://blogs.office.com/b/microsoft-...ent-field.aspx

[PeachTosser25]

No, that's not what I need..
That does help though, altough I can't figure out how to map that code for opening the attachment to the OnClick event for the label.. but that isnt my main priority right now.
First, I need to figure out how to open an Upload Attachment dialog box when the CheckBox is marked as Yes. I tried googling it, but now all that pops up that's relatively related is this thread.