Automatically filling fields on a form

[Guest]

I have a form where the user has to tick a number of boxes to indicate the
audience the data relates to [Location1], [Location2], [ALL]

If the user ticks [ALL] is there a way to automatically tick the [Location1]
and [Location2] boxes?

 

[Guest]

Private Sub All_AfterUpdate()
If Me.All = -1 Then
Me.Location1 = -1
Me.Location2 = -1
End If
End Sub

 

[Guest]

Thanks Wayne - That worked perfectly!

Private Sub All_AfterUpdate()
If Me.All = -1 Then
Me.Location1 = -1
Me.Location2 = -1
End If
End Sub



--
Wayne
Manchester, England.

I have a form where the user has to tick a number of boxes to indicate the
audience the data relates to [Location1], [Location2], [ALL]

If the user ticks [ALL] is there a way to automatically tick the [Location1]
and [Location2] boxes?