Control button on a report to change a field value?

[Japazo]

I have set up a system which allows our sales team to initiate a quote for a customer. One of the managers will then complete the quote, seeing that it has been initiated. If accepted, the quote will be converted into an open job where a bunch of documents are created. At the same time, a report will be updated to show that the new job has been created, so it can be entered into our financial system. What I would like to accomplish is to create a button which would appear for each record on the report (I have successfully created the button for each record...). I want the button to be tied to the record itself. Once the information has been entered into the financial system, I want our accountant to be able to hit the button and "delete" the record from the report so they can move on to the next job. I really just want the button to change the "job status" field to something other than "new job" so the record will no longer appear on the report.

Is this possible? If so, how do I get the button to change the correct field? I'm sure the code or macro wouldn't be all that complicated, but how hard is it to have the button, which is automatically generated for each record, tied to its corresponding record and only effect that particular record?

Any ideas are appreciated! Thanks!

[June7]

You say 'report' but is this actually a form object? On a form can select record and hit Delete on the keyboard. On a report, expect will require VBA code and DELETE sql action statement.

[Japazo]

You say 'report' but is this actually a form object? On a form can select record and hit Delete on the keyboard. On a report, expect will require VBA code and DELETE sql action statement.

It is an actual report. All I really want is a quick way for accounting to clear the job from the "new jobs" list without having to navigate through forms. I would like them to be able to do everything from a single report.

[June7]

What is 'new jobs' list?

Reread original post. You don't actually want to delete a record, just change value in a field? Okay, that is an UPDATE sql action. In button click event, something like:

CurrentDb.Execute "UPDATE tablename SET fieldname='some value' WHERE ID=" & Me.ID

Never tried this from a report event. Good luck.

[Japazo]

What is 'new jobs' list?

Reread original post. You don't actually want to delete a record, just change value in a field? Okay, that is an UPDATE sql action. In button click event, something like:

CurrentDb.Execute "UPDATE tablename SET fieldname='some value' WHERE ID=" & Me.ID

Never tried this from a report event. Good luck.

I've taken a few steps backward with my DB so this is on the back burner. Thank you for the help, I'll try it as soon as I get that far again!