Select all in a continous form

R

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?
 
M

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?
Click to expand...

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
 
Top