Select all in a continous form

  • Thread starter Thread starter Ryan Tisserand
  • Start date Start date
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?
 
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
 
Back
Top