Updating Fields Through Code

[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.

 

[Larry Linson]

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

 

[hal boyles]

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