Welcome to the skill header Forums. You can ask questions, get help, or help other members out. Join our Forum for free.
What am I doing wrong here.....I remember something about using single-quotes instead of double-quotes on statement inside the whole statement double-quotes with MS Access 365. Seer attached image to see where the error is pointing to as the problem. I have triple and quadruple checked against your code on YT.
docmd.RunSQL " UPDATE tbl_Order_Items " _ " SET tbl_Order_Items.ItmQtyInvoiced = " & inv_ord_q & ", " & _ " tbl_Order_Items.itmQtyInvoiced = " " " & inv_ord_q & _ " " " WHERE tbl_Order_Items.OrderItemsID = " & me.OrderItemsID & ""
Well, it happens every time, I get frustrated and reach out for help and then a flash happens, and I see the problem. in this case I was missing an ampersand sign after the Update line. Corrected the code and it now my where statement is off somehow.....
DoCmd.RunSQL " UPDATE tbl_Order_Items " & _ " SET tbl_Order_Items.ItmQtyInvoiced = " & inv_ord_q & ", " & _ " tbl_Order_Items.itmQtyInvoiced = """ & inv_ord_q & _ """ WHERE tbl_Order_Items.OrderItemsID = " & Me.OrderItemsID & ""
Received the source files this morning and spent a few hours cleaning up the mess I created in my version of the project. Thank you Ursh, you saved me again. All my SQL statements were trash as well as I misnamed the two critical sub forms using sfrm_ instead of tbl_. Speaking of which, why did you do that? Typically, I look at coding to direct me to the object I need to focus on. If there is a reason for later needed in the project, please advise.
