Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2004
    Posts
    13

    Red face Unanswered: Trying to update some tick boxes from a single click

    Hi,
    A bit of advice needed please.
    I have a form for a membership database that has 4 tick boxes for each of the magazines that get sent.
    I already have queries set that when the mailshots are run will tick each box in turn (set as Sping, Summer, Autumn, Winter).

    The forms gets it's information from a query single_user_query that asks for a members name and displays the result in the single_query_user_form

    What I want to do is have a button that can be clicked on the form so when someone renews membership it will reset the tick boxes to 'false'

    I'm assuming there's some sort of code or expression I can use, but not really sure the best way to start.

    Any help appreciated!

    Cheers

    Darth

  2. #2
    Join Date
    Jun 2004
    Location
    Nottinghamshire, UK
    Posts
    14
    Darth

    A quick and easy way:

    Code:
    Private Sub Command12_Click()
    'Reset checkboxes
        Me.chk1.Value = False
        Me.chk2.Value = False
        Me.chk3.Value = False
        Me.chk4.Value = False
    End Sub
    HTH

  3. #3
    Join Date
    Aug 2004
    Posts
    13
    Thanks Graham,

    That's done exactly what I need.

    Cheers

    Darth

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •