I have a select query that shows all orders placed during the day. The status of the order is "ordered". The query works fine, and it is placed on a form. What I have to do is to change the status of each order separately when the package is sent.
I have created a column on query that displays "mark as sent", changed it in form options to always display as hyperlink. I have tried to make onClick event, but I am missing something in WHERE clause. I have tried with
but it changes the order status of the entire Sales table. Not sure if I can place condition in WHERE clause like this at all.
Any help is appreciated.
I have created a column on query that displays "mark as sent", changed it in form options to always display as hyperlink. I have tried to make onClick event, but I am missing something in WHERE clause. I have tried with
Code:
CurrentDb.Execute "UPDATE tblSales SET Status = 'Sent' WHERE ID = tblSales.ID"
Any help is appreciated.