By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 1,410 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

Using checkboxes to decide what records go on a report

P: 1
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.
Feb 3 '08 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 374
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.
If I understand your question correctly, you want to be able to update a value in the table called Claimed that is a yes/no field type from the main form that you're using to update this field by. If so here is what you're going to need to do.

Just simply bind the value in the table to a checkbox on the form.

If this is also updating another table that isn't bond to the form that you're checking the box on, then there's going to be a little programming involved to be able to do that.

I need to have more detail as to the structure of your database in order to give you a detail answer to that.

If you would like, you can email me at me@joepottschmidt.com for details.

Thanks,
Joe P.
Feb 4 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.