What is wrong with this code?
Private Sub CmdShipped_Date_Click()
On Error GoTo Err_CmdShipped_Date_Click
Dim strSQL As String
strSQL = "UPDATE tblOrders SET tblOrders.ShippedDate = [Enter date to set]" & _
"WHERE tblOrders.OrderID = BETWEEN [Enter starting Order #] AND ([Enter ending order #]));"
'Dim stDocName As String
'stDocName = "qryupShippedDate"
'DoCmd.OpenQuery stDocName, acNormal, acEdit
I have a query that works, but I am trying to graduate to VBA coding for my SQL stuff. What I'm trying to do is set the shipped date on a set number of orders.