Selection check box on form

  • Thread starter Thread starter Jeff Gil
  • Start date Start date
J

Jeff Gil

I would like to have a check box on a continuous form that
when checked, would allow the checked records on the form
to be included on a report. The underlying query for the
form is based on an un updatable recordset. So I am
unable to simply use a yes/no feild from that query. I
tried using a subform (which has an updatable recordset)
but with the subform I am unable to use a continuous main
form. Basically I would like to use a form that would
be "interactive" and allow the user to sort feilds in the
form if needed, and then select which records to include
in a report. Any suggestions?

Thanks
Jeff G
 
Put the Yes/No field, to be used for this purpose, in the primary Table of
your updateable Query. Clear it with an Update Query before using it. You
really can't do what you want with an unbound Control. Your Report's
RecordSource will simply include a Criteria that the Field is Yes/True.

Larry Linson
Microsoft Access MVP
 
Larry-
The query is NOT updatable - sorry I wasn't too clear on
this in my original post. So the y/n field (and any other
values) can't be updated on the form. This is the problem
I am attempting to overcome.

Maybe I can dump the recordset into a temporary table in
conjunction with opening the form and have the form look
at data from the temp table? It is not something I have
done before.
JG
 
I decided to go the create table route and it worked fine.
-----Original Message-----
Larry-
The query is NOT updatable - sorry I wasn't too clear on
this in my original post. So the y/n field (and any other
values) can't be updated on the form. This is the problem
I am attempting to overcome.

Maybe I can dump the recordset into a temporary table in
conjunction with opening the form and have the form look
at data from the temp table? It is not something I have
done before.
JG
-----Original Message-----
Put the Yes/No field, to be used for this purpose, in
Click to expand...
the
primary Table of
Click to expand...
 
Back
Top