I created a grid control on my form. The grid filled from a database(Access). I created a routine where I can add an item to my grid without any problems, but I can't seem to figure out how to delete that same item. I declared the variable Table as Recordset and put in the following line of code:
Dim Table as Recordset
Set Table = dbTFH.OpenRecordset("Trucks", dbOpenTable)
Table.Index = "ID"
Table.Seek "=", grdtrucks.Text
When I use the 'Table.Delete' method I continually get an error message saying, "Run-Time error '3021', No current Record" and it points to my 'Table.Delete'.
Do you have any ideas on the matter?