Results 1 to 2 of 2
  1. #1
    chiefmsb is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2006
    Location
    rockville centre, ny
    Posts
    23

    check boxes


    I have a form called history with a field check box named smokes and another field called smokes amount. i want to hide the smokes amount field on the form and show it only when the smokes checkbox is checked. how do i do this. I am an old foxpro programmer from about 15 years ago and have forgotten alot plus that was windows 3.1 and not very graphical..thanks for any help.

  2. #2
    Join Date
    Nov 2006
    Location
    Arlington Heights, IL
    Posts
    7
    In the Properties of the "smokes amount" field set the Visible property (under the "Format" tab) to No. In the "smokes" check box Properties create an event procedure ("Events" tab) under the "After Update" property that will make the "smokes amount" field visible if the "smokes" check box is clicked true. The code will look something like this:

    If [smokes] = True
    Then [smokesamount].Visible = True
    End If

    Thanks,
    ScottG

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 05-29-2014, 09:58 PM
  2. Yes/no boxes on forms
    By KEN in forum Forms
    Replies: 0
    Last Post: 09-10-2008, 10:56 AM
  3. Replies: 0
    Last Post: 04-19-2008, 09:08 PM
  4. Apply check at record level
    By wasim_sono in forum Programming
    Replies: 1
    Last Post: 04-19-2007, 07:48 AM
  5. Check Box issues
    By data123 in forum Forms
    Replies: 0
    Last Post: 01-03-2007, 03:21 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums