selecting records with a tickbox on a form

[Guest]

hi everyone,
I am trying to make a form to tick off which cheques and cash which have
been banked this day for the accounts dept. Im using a simple union query
which brings up all the due payments just fine. what i need to do is make a
simple form which allows the user to tick off the payments that were banked
and leave the ones that were held (to be banked another day). I dont have a
tick box field in the tables for cash or cheque but i want to be able to tick
them and the ones which are ticked are updated with the date in a date
textbox on the form.

What is the best way to do this? do i use a continuous from, subform, then
how do i select the ones i want to tick off?
The main problem ive had is putting a tickbox for each record, i cant create
this in the query. do i just make very thin forms for each record and run a
sub for the tickbox and inserts the date as required?

any input will be most appreciated as i can use this solution in several
forms.

Amit

 

[Guest]

Amit,

I believe you will need to add a field to your table (yes/no property) and
then add a check box control to your form that is bound to that field in the
table.

This will show a check box on every record.

hth