Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    Canton, Ohio, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Bounded Check Box (2000)

    This is probably a very easy question to answer but I just can't figure it out.

    How do I set a bounded check box so that it is checked when the form it is on is opened?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Bounded Check Box (2000)

    If the check box is bound to a Yes/No field in the record source of the form, its state will reflect the value of the Yes/No field in the record that is displayed when the form is opened. Are you sure you want to change the value of this field when the form is opened?

  3. #3
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    Canton, Ohio, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bounded Check Box (2000)

    This form is only used to lock a record. The user clicks a button to open the form and can add remarks if they wish and check the check box to lock the record. If they don't have any remarks to make, I'd like to make it easier and quicker for them to lock the record. They would just open the form and if the form opens with the check box checked, they could just close it. The form is never used unless they are locking the record.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Bounded Check Box (2000)

    OK, thanks for the explanation. Say that the check box is named chkMyCheck. Put the following code in the On Load event of the form:

    Private Sub Form_Load()
    Me.chkMyCheck = True
    End Sub

    If the user can move from the initial record to other records, and you want the check box ticked there too, use the On Current event instead of the On Load event of the form:

    Private Sub Form_Current()
    Me.chkMyCheck = True
    End Sub

  5. #5
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    Canton, Ohio, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bounded Check Box (2000)

    Thanks Hans

Posting Permissions

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