Basically, I need to update a certain record to be 'closed' when I hit a button depending on the 'serial number' that is typed in the text box above. I'd like not to bind the form to anything however. How can I do this?
Actually I think the query would run faster, but either most likely will run fast enough since you are only updating one row you would not notice as long as it is designed properly. If were updating mulitple rows, I would say the query has an advantage in speed.