checkboxes in ACCESS 2007

[MarkGardner]

I have created a forms and have used BUTTONS to cause an event to occur.
Now I would like to use a form that displays all of the records of a table and to be able to use a CHECKBOX for each record to accumulate all of the records selected so that I can accumulate from among all of the records in the table a few selected records to print from another table the selected records.

I place the checkbox in the form without problems and the checkbox appears next to the record without problems. I then attempt to place a check in checkbox next to the record that I want to flag and all of the checkboxes get checked.

The next problem related would be on how to set the criteria so that the Query will look at only the checkbox items before printing.

I am using ACCESS 2007 and do not do VBA nor SQL. I am looking for a solution within ACCESS objects themselves and not VBA nor SQL.

Thank you to anyone that can assist, since I cannot find anything that can help in any of the books that I have.

Mark Gardner

 

[mvorous]

Mark, hi, I'm no expert, but I think your problem is that your checkbox is "unbound". It needs to retain its value, saying that, it needs to exist in your table.
Hope that that is it.
mvorous

 

[wiklendt]

oooo.... putting together a database without the use of VBA or SQL... good luck, mate!

 

[missinglinq]

But Micro$oft says you can, so it must be true!