Update question

[jehm]

I want to set the field Suborder from the table orders to true when i issuing an order.In my main form
i have a control with the following code

If Me!ChkSubOrder = True Then
strSQL = "UPDATE orders SET Suborder = True WHERE orderid= Me!orderid FROM orders)"
End If


However the field for the relevant order is not set to True.I must have an error in my code.Could you help me ?

 

[HandsOnAccess]

Here is the correct Code...

If Me!ChkSubOrder = True Then
strSQL = "UPDATE orders SET Suborder = True WHERE orderid = " & Me!orderid
End If

Alternatively You can just bind the ChkSubOrder to Suborder
It will automatically update without any coding
i.e., make Suborder as controlsource for ChkSubOrder

Hope this helps...
Regards,

 

[HandsOnAccess]

oh in the above post there is one line of code left out

Here is the revised code

If Me!ChkSubOrder = True Then
     strSQL = "UPDATE orders SET Suborder = True WHERE orderid = " & Me!orderid
     DoCmd.RunSQL strSQL
End If