Just got a quick query well im hoping it is a quick one!
What i am trying to do is update records with an item table when it is removed. At the moment what is happening is if i have say 10 items and the remove button is pressed it is deleting all the records within that hire , which is fine, I can also get it to update the first item within the listbox. But it does update the other items that were within the listbox.
I know what the problem is, this is what i am using. The findfirst is only finding the first item within the listbox that matches the item table. Is there a way for it to retrieve all the items that are removed? Hope it makes sense
Expand|Select|Wrap|Line Numbers
- Set rsitemline= currentdatabase.OpenRecordset("select * from itemhire Where itemno =" & Forms!frmitemhire!txtorderno)
- Set rsirtem= currentdatabase.OpenRecordset("tblitem")
- rsirtem.FindFirst ("[itemno]='" & rsitemline("itemno") & "'")