Question about after running a report

[bigbadbess24]

I am not sure if this is place to put this.
I am running an auction. I have a report that runs from a table. To get this report I run a form that I plug in the paddle number and prints out their receipt with all the items they won.
Sometimes they will come up and want to pay each item separately. When they come back for the second time I do not want to put the first item they already paid for on their second receipt.
Is there a way I can set it up so after they pay, the item will be check off? I was thinking of putting in another column in the table and have it put an X in there and when I run my query have it set to "Null" But I am not sure how to get that X in for the item after I run the report.
Thank you

 

[Moniker]

Your report has to be based on a table. It could be based on a query, but that query will still be based on a table.

Anyway, it's in that table where you want to put a "paid" checkbox and then you change the report's record source to be "where paid is NULL". You can't do that in a report as a report is just a view that is not editable. It would have to be done on a form or other editable structure, and then the report would have to be refreshed for the correct output.

 

[bigbadbess24]

Yes I understand that. So that is why I am asking is there a way to doing that