Hi, I am fairly new to access and I've been spending the last week trying to figure out how I can select certain records to go on a report.
On my main form, I have journal titles listed and under each journal I have issues that I check into the form and each issue has its own record in my check-in table. If I do not receive an issue, I want to be able to check a checkbox that I have named "Claimed". Once I have received that issue I will uncheck it. I have added a column in the "Check-in" table named "Claimed" and it is a yes/no field.
I'm not sure if I even started this correctly, but once I check the checkbox in the form, I want it to update the record in the table and make the value in the "Claimed" field for that record true or yes or 1 or whatever it is suppose to be so that when I design a report I can select the report to only include items that have been checked claimed.
How will I go about even doing all of this?
I'm not even sure if I should use the Expression Builder, Macro, or Code and if it goes in the OnClick property of the checkbox.
If anyone can help me, or possibly suggest another method that may be easier it will be greatly appreciated.