Form Field Value

[Little Penny]

I am having a problem with my update query. I'm trying to combine the
field values of two open forms in to a variable and set it as the
update value in my query. However I get a MSGBOX asking me to "Enter
Parameter Value" for cba. Not sure why

My Code:




cba = Forms![frmOrderRequest]![OrderName].Value &
Forms![OrderNumber]![txtSearchString].value


DoCmd.RunSQL ("Update tbl_Orders set tbl_Orders.OrderName= cba " & _
" where tbl_Orders.OrderID=" &
[Forms]![frmOrderRequest]![OrderID])




Thanks




Little Penny

 

[Ken Snell [MVP]]

You need to concatenate the value of the cba variable into the string:

DoCmd.RunSQL ("Update tbl_Orders set tbl_Orders.OrderName= " & cba & " & _
" where tbl_Orders.OrderID=" & [Forms]![frmOrderRequest]![OrderID])