update records using checkbox and button

[markosubino]

so here i got a table that has, fields , ID, SERIAL, Status.
what i want is to update the Status from of all or number of records selected using a checkbox,
one button to update it all or the selected records,

[ranman256]

so if the record is checked , update that record(s)?

update table set [field] ="new value" where [checkbox]=true

[CJ_London]

1. you will need to use a form, tables do not have buttons
2. to use a checkbox you will either need to add a 'checked' yes/no field to your table or use what is called a disconnected recordset and a lot of code
3. or there is this method here which does not use a checkbox https://www.access-programmers.co.uk...d.php?t=289116