datasheet subform checkbox to all checked

[mwilliams4]

I have a subform which is a datasheet that has a checkbox (Y/N) field
that I would like to check all by using a button on the main form. I
would do this after filtering down to the records that I want to check
off then hit the button to check them all. I want to make sure that
I'm only checking those "filtered down records", and not the entire
table.

Any help would be appreciated.

 

[mwilliams4]

sorry, it's Access 2003 that I'm using.

 

[Marshall Barton]

I have a subform which is a datasheet that has a checkbox (Y/N) field
that I would like to check all by using a button on the main form. I
would do this after filtering down to the records that I want to check
off then hit the button to check them all. I want to make sure that
I'm only checking those "filtered down records", and not the entire
table.

For that to happen, the field and all the (filtered) records
will be updated in the table. If you are sure that's what
you want, make a backup of the table and try this:

With Me.RecordsetClone
.MoveFirst
Do Until .EOF
.Edit
!thefield = True
.Update
.MoveNext
Loop
End With

 

[mwilliams4]

I get error 7951, invalid reference to a recordsetclone property.

Here is the button code in the main form Y/N field name is BillingYN


Private Sub Command2_Click()

With Me.RecordsetClone
.MoveFirst
Do Until .EOF
.Edit
!BillingYN = True
.Update
.MoveNext
Loop
End With

End Sub

 

[Marshall Barton]

I get error 7951, invalid reference to a recordsetclone property.

Here is the button code in the main form Y/N field name is BillingYN


Private Sub Command2_Click()

With Me.RecordsetClone
.MoveFirst
Do Until .EOF
.Edit
!BillingYN = True
.Update
.MoveNext
Loop
End With

End Sub

I think that implies the main form does not have anything in
its record source property. That tells me your button is on
the main form and the records are in the subform. If I
finally got it straight, change the With statement to:

With Me.subformcontrol.Form.RecordsetClone

 

[mwilliams4]

Worked like a charm--THANKS!!!!