I'm trying to update a multi-valued field (attachments) using the following SQL but I'm getting the following error:
An UPDATE or DELETE query cannot contain a multi-valued field. 3826
If Me.LstAttachment.ListCount > 0 Then
For I = 0 to Me!LstAttachment.ListCount -1
Attch = Me.LstAttachment.ItemData(I)
sSql = "UPDATE tbl_IssueLst " _
& "Set ShareDoc = ' " & Attch & " ' " _
& "Where ID = " & Me!ID
next I
End If
What are my alternatives of getting this MVF updated?