checkbox per record in a subform

[Guest]

Hello everyone,

what i got is a form which is required to check if all checks, cash etc are
due to be banked today and then use a checkbox to tick off the ones that are
going to be banked, which will inturn import a banked date into that records
[bankedDate] field.

Ive got a working union query to bring all the records together from
different tables and was thinking of using a subform (table format) to list
the records that are returned by this query. But what i want is a checkbox
next to each record that allows you to go down the list and pick the ones you
wish to bank which i cant seem to do in this form.

Any ideas? can i programatically add a checkbox per record in the underlying
subform query or should i use a continuous form format and add a checkbox to
it, any suggestions for concise but workable presentation?

with much thanks

Amit

 

[Guest]

An unbound checkbox control on a continuous form can have only one value for
ALL records. Add a Yes/No field to the appropriate table in your query, and
a checkbox bound to it in your form.

Sprinks