Access Manage Attachments linked to a SubForm

Jul 7, 2017
Reaction score

I'm basically new with Microsoft access, especially with handling codes. I'm currently stuck now with figuring out how to link my command button to a SubForm. Any ideas how I can get it to work?

End Goal: Clicking the Manage Attachment Button opens the ManageAttachments Command to enable users to edit the attachments on the Form itself.

The Table Source for all this contains information about names and number of our contacts. So the Main form is suppose to look like this:

The SubForm is a continuous form that is designed so that it shows all attachments saved per specific ID.


This is the VBA Code I'm working on to invoke the Manage Attachments command whereas
ManAtt = Manage Attachments Button
SbFrmAttach = Sub Form
Attachments = Attachment file type on the left side of the form

The VBA Code Goes Like this:

Private Sub ManAtt_Click()
With Me.SbFrmAttach
RunCommand acCmdManageAttachments

End With
End Sub

Again, I'm fairly new with using Access and VBA so please have patience with me.


  • upload_2017-7-7_14-17-30.png
    19.1 KB · Views: 158


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question