QueryDef definition

mchoud

Registered User.
Local time
Today, 16:48
Joined
Jun 3, 2003
Messages
25
Dear All

I have code like the following, and when i try to run this code, there is an error message appeared " user define type not defined ?

what its mean ?

Private Sub Command5_Click()
Dim qdf As QueryDef
If vbYes = MsgBox("Are you sure want to delete the current record", vbYesNo) Then
Set qdf = CurrentDb.CreateQueryDef("", "DELETE * FROM bincard WHERE contro_id = '" + Me.bincard_sub.Form!contro_id + "'")
qdf.Execute
MsgBox "The record has been deleted"
Me.SupplierSub.Form.Requery
End If
End Sub

Thanks
mchoud
 
Good job Mile-O-Phile!
 

Users who are viewing this thread

Back
Top Bottom