check all that apply

[matthew nance]

i want users to mark a check box for all the records that
they want included in a report. how do i do this?

i have a form with a combo box and command button. The
user selects from the combo box and when he clicks the
command button it opens another form from a query with all
the records that mean the combo box's criteria. i want
this new form to have check boxes for the user to select
all the records that he wants included. when a "print
report" is selected from the originail form the selected
records should be included on the report.

i'm using access 97 with windows 95.
thanks,
matthew

 

[MacDermott]

Add a yes/no field to your underlying table.
You can then bind a checkbox on your form to that field.
Remember to set all the checkboxes back to No after you run your report.

HTH
- Turtle

 

[Matthew Nance]

you're a genius. it works. now i just can't figure out
how to reset the yes/no values in my tables to no. any
help?

thanks,
matthew

 

[Douglas J. Steele]

Easiest way is an Update query that updates the field to False.

 

[Matthew Nance]

that was easy, thanks. i put in a command button on my
form to run the query. any way to keep those pesky pop-up
messages from coming up? the first says "you're about to
run an update query" the second "you're about to update
4000 records"

thanks,
matthew

 

[MacDermott]

DoCmd.SetWarnings False
Run your query
DoCmd.SetWarnings True

Be aware, though, that this can cause you to miss meaningful warnings, too.

HTH
- Turtle

 

[Doug Munich]

Would this work properly if more than one user tried to produce a report at
the same time?

Doug

 

[MacDermott]

Probably not.
If that's a serious concern, you could use a local table.

- Turtle
With Access 97 on Win95, I'm guessing he doesn't have a lot of concurrent
users.