Updating Fields Through Code

  • Thread starter Thread starter JP
  • Start date Start date
J

JP

I have a print invoice button which looks for a status
field to be "Ship It". When I hit the print invoice
button I want to change the field to Shipped for all items.
 
JP said:
I have a print invoice button which looks for a status
field to be "Ship It". When I hit the print invoice
button I want to change the field to Shipped for all items.

Clarify what data you have, and how you have organized it into tables, where
the "status" field is, and I'd wager someone will be able to help. Please
clarify here in the newsgroup, not by e-mail.

Larry Linson
Microsoft Access MVP
 
create and call an update query to change the value of that field to
"whatever" with criteria in the query pointing to the "id" of the record in
question
 
Back
Top