reference the correct button when selecting a record

[rwahdan@gmail.com]

I have a continuous form that includes all records in one form. I added a button called "Edit" for each record and when clicked it changes its caption to "Update". Currently it is changing the caption of that button for all records to "Update". How to make it only change the caption of only the selected record and disable the rest of the buttons for other records.

Thanks.

[aytee111]

These functions are done automatically by Access, the user can already edit and Access will take care of the updating. Or is there more that you haven't mentioned?

[isladogs]

Cross posted at https://www.access-programmers.co.uk...d.php?t=298161

[June7]

Cannot do what you ask for. There really is no need for this button anyway if form is BOUND to data source. Edits are committed to record when 1) close table/query/form or 2) move to another record or 3) run code to save.