I'm using MS Access 2003.
Probably a dumb question, but I'm not finding the answer anywhere.
I have a command button that I'd like to use to logically delete the record and update the change to the database: When the user clicks the button, the Clicked event would change the value in the Status field to "D", then update the record.
I can get it to change the value in the textbox to "D", but I'm not sure how to programmatically update the record. Instead, after clicking the button, the Edit ("pencil") icon displays and I have to click off the record to save the change.
How can I do this in code?
Thanks.
Wayne
Probably a dumb question, but I'm not finding the answer anywhere.
I have a command button that I'd like to use to logically delete the record and update the change to the database: When the user clicks the button, the Clicked event would change the value in the Status field to "D", then update the record.
I can get it to change the value in the textbox to "D", but I'm not sure how to programmatically update the record. Instead, after clicking the button, the Edit ("pencil") icon displays and I have to click off the record to save the change.
How can I do this in code?
Thanks.
Wayne