Hello Sir
Dear Sir,is it posiable to write SQL statement in the
command button,s click event to update,delete or insert
a new recard to database.if it is posiable for you,
please give me some examples.
Thanks

arshad mahmood

__________________
arshad mahmood

Give this a shot:

Private Sub Command1_Click

Dim cxn as Connection
Dim strSQL As String

With cxn
   .ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
          "Absolute Path to your database here"
   .Open
End With
strSQL = "UPDATE myTable " & _
         "SET myTable.Field1=True " & _
         "WHERE myTable.Field1=False;"

cxn.Execute strSQL

cxn.Close
Set cxn = Nothing

End Sub

Kenny Alligood