Select all in a continous form

[Ryan Tisserand]

Access 2003
Vista Business

Mainform = MailingLabels
Subform = Transactions

In [Transactions] I have a text field named [Printed]. In my Mainform I
have a checkbox called [Selectall]. Is it possible to have ALL records in
[Transactions]![Printed] = "Yes" when [MailingLabels]![Selectall] checkbox
is checked?

 

[Minton M]

Access 2003
Vista Business

Mainform = MailingLabels
Subform = Transactions

In [Transactions] I have a text field named [Printed]. In my Mainform I
have a checkbox called [Selectall]. Is it possible to have ALL records in
[Transactions]![Printed] = "Yes" when [MailingLabels]![Selectall] checkbox
is checked?

To do this, you would need a field in the subform's recordset (a yes/
no field with printed) which your main form would update. If you link
this field to your subform, it will become visible. You can't use
unbound controls in subforms that have distinct values per record.

-- James