Automatically filling fields on a form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TomTomRBS - 05 Sep 2007 10:40 GMT

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?

Reply to this Message

Wayne-I-M - 05 Sep 2007 11:16 GMT

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

Signature

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?

Reply to this Message

TomTomRBS - 11 Sep 2007 13:56 GMT

Thanks Wayne - That worked perfectly!

> Private Sub All_AfterUpdate()
> If Me.All = -1 Then
[quoted text clipped - 8 lines]
> > If the user ticks [ALL] is there a way to automatically tick the [Location1]
> > and [Location2] boxes?

Reply to this Message