Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

#DELETED

Status
Not open for further replies.

Domino2

Technical User
Jun 8, 2008
475
GB
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.

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
 
Solved, I was not re-querying table Me.List547

Now shows cleared list
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top