I have a form in which the user inputs data and then some VBA processes and checks this data before putting into a table. The Form fields are not directly bound to the table.
I want to modify this form to include an Attachment Control field, which is Unbound, which I can then assign to the table field in the VBA code.
I have added an Attachement field to the table and an Attachment Control to the form and then added a line in the VB to assign the value of the Attachment to the table field in the normal way:
Set rs = CurrentDb.OpenRecordset("tblDocumentReviews")
rs.AddNew rs("Document Reference") = Me.Document_Reference
rs("Version") = Me.Version
rs("Revision") = Me.Revision
rs("Attachment") = Me.Attachment
However, when I open the form the Attachment Control is apparently disabled and clicking it does nothing.
If I create a form which is bound to the table, then I can add attachments in the way described in the MS Office online help.
Can anyone let me know if it's simply not possible to do what I'm trying to do? What would be a good alternative? I can't have the form just bound to the table because I need to process the input data before assigning it to the table.