Continuous forms and non bound controls

C

Chris Strug

Hi,

I have a bound form, linked to a query. What I'd like to achieve is for the
user to be able to flag certain records for processing later. Specifically,
given a continuous form with a few dozen records, I'd like the user to be
able to select which records he wants to print.

However I'm not completely sure how to achieve this. I've tried including an
unbound tickbox control in the detail which appears with each record as
expected. How ever, changing the value of the tickbox changes all the
tickboxes for every record...

I'm guessing that this is a limitation of continuous forms and that there's
not much I can do about it. However I would really like to be able to
display a list of bound data and have the option to flag records for later
use. I'm just a bit clueless as to how to achieve it...

One idea I had was to create a disconnected ADO recordset in memory and add
record IDs as they're selected (or remove as they're deselected) and then
from there print the relevant reports when required. However I'm still a bit
lost as to how enable to the user to simply select records and track that
selection.

Does anyone have any pointers?

Any and all advice is gratefully received.

Kind thanks

Chris.
 
R

Roger Carlson

What I have found to be most successful is to create a field called
"Selected" and bind the check box to that. I use an Update query to set all
the values to false on the OnCurrent event of the form, so every time I move
to a record, the field is cleared. Having a bound control eliminates more
problems than it creates.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
R

Rick Brandt

Roger Carlson said:
What I have found to be most successful is to create a field called
"Selected" and bind the check box to that. I use an Update query to set all
the values to false on the OnCurrent event of the form, so every time I move
to a record, the field is cleared. Having a bound control eliminates more
problems than it creates.

Of course that wouldn't work in a multi-user environment unless you employed
(per-user) temp tables or such.
 
A

Albert D. Kallal

I have a nice little working sample that takes VERY little code,a nd shows
you how to use a check box to select records for processing, and you don't
even need to use a check box in the field. In fact, the check box is thus
not based on a field...but a function. Thus, the check box is not bound to a
field, but in fact I use a collection object.

It works well, and takes VERY little code.

You can find the example here:

http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html
 
S

Stephen Lebans

Most excellent Albert!
This is the first time I have seen an unbound CheckBox that works so
well and so easily.
Definately a keeper!
:)

I wonder if I could make a CheckBox type ListBox using a Form in
Continuous view with your solution. Hmmm...have to give it a try.
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
J

Jeff Conrad

Very cool Albert!
It even works for Access 97 as well.

Now I just have to go back and change all my 'launch-report' forms.
<g>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top