I am getting a list box display #DELETED when I delete an item in a non linked table. The list box is bound to the table.
Both tables are not linked.
Both tables are not linked.
Code:
For Each item In Me.List547.ItemsSelected
strlist = Me.List547.Column(1, item)
' Put Keyword in Keywords File rs6
rs6.AddNew
rs6!Keyword = strlist
rs6.Update
' Remove from Temporary List Table (Keywords)
rs5.FindFirst "DumpedWord ='" & strlist & " '"
rs5.Delete
Me.List2.Requery
Next item