How do I delete a record from a subform

captainlove · April 28th, 2008, 08:09 AM

Here is my code, but it is not working. The error is saying user defined type not defined.

Private Sub cmdinsertlist_Click()

Dim Rs As DAO.Recordset
Set Rs = CurrentDb.OpenRecordset("Select * From tblrefLink Where refID = " & Me.ID & " And UserID = '" & Forms.frmqcpList2.txtQcp & "'")

If Not Rs.EOR Or Not Rs.BOF Then
    Do Until Rs.EOF
       Rs.Delete
       Rs.Update
       Rs.MoveNext
   Loop
   Rs.Close
End If

Set Rs = Nothing

End Sub

lucasfatoye

prabodh_mishra · April 29th, 2008, 12:01 AM

In which language are you trying all this, VB or ASP? What does Me.ID and Forms.frmqcpList2.txtQcp denotes?

Prabodh

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Deleting a record from a subform	captainlove	Access VBA	3	May 1st, 2008 11:38 AM
Delete a record row, not just the record.	Coby	Access VBA	1	April 30th, 2007 06:29 AM
setting subform to new record	skinny	Access	4	January 3rd, 2006 02:57 PM
Creating a new record in a subform	dlamarche	Access	3	February 18th, 2005 12:33 AM
Subform only may contains 1 record	Stanny	Access	5	December 21st, 2004 11:17 AM