Check/Option Boxes on Continuous Forms

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I have a continous form that needs to show either check or option boxes
(doesn't matter which) to indicate whether a record should be selected for
printing or not. As there is no control source for the box (it will be used
later by a query), checking one checks the lot! I know this has been asked
before, but what is the easiest way of overcoming this. Please be gentle in
your replies as I am learning VBA as I go along.

Regards

Tom
 
Thanks for the reply.

I have just got into the list box option as I have read elsewhere that
option boxes can get screwed up with multi-user databases - this is
multi-user.

Thanks again

Tom
 
Tom

The only way to have different values (True / False) for the CheckBox in the
CTsFormView is that it has to be bound to a Field.

Probably the easiest way is to have an extra Boolean Field in your Table.
Before you open the Form, set the Field value to False for all Records using
an Update Query or SQL String. Bind this Field to the CheckBox and then the
user will be able to check / uncheck each instance of the CheckBox Control
separately.

One thing you will need to watch out for is that if the database is a
multi-user database, 2 or more users can operate instances of the same Form
and this will muck up the values of the Boolean Field.

If you only use the CtsFormView for record selections for a later process, I
would recommend a Multi-Select ListBox instead.
 
Hi Albert

Thanks for the code. I got it working in mine eventually - had a few
problems as my 'userid' variable is a text string so it came up with an
error when passing the data to the report as it tried to pass the id field
as numeric. I worked out how to get them into single quotes and it works -
thanks.

My next challenge is how to take this information and put it back into a
query so that it can be appended to a different table.

Any ideas? (I am working my way through a self-teach VBA tutorial and I have
not got as far as writing to tables yet).

Regards

Tom
 
Back
Top