Results 1 to 3 of 3
  1. #1
    Dusten is offline Novice
    Windows 7 64bit Access 2002
    Join Date
    Feb 2018
    Posts
    1

    Problem with checkbox on forms

    We used Access to create checksheets that are to be used every 12 hours. I made some changes to the form (added a couple new check boxes) they seemed to be working. But what i didn't notice is that when you checked one of those new boxes on the current form that it also checked the same box on the next form.....(the next days check sheet)

    So there must be a setting that I missed that will only alow checkboxes that are checked to show up on the current form only....

    I'm using a very outdated Access as well...I think 97.



    Thank you in advance for any assistance.

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Have you added a field to the forms record source and bound the check box to that field
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    Quote Originally Posted by Dusten View Post

    ...when you checked one of those new boxes on the current form that it also checked the same box on the next form.....(the next days check sheet)
    I assume by 'current form' you actually mean current Record, and going from there...the answer to Bob's question would have to be 'NO!'

    The latest data entered in an Unbound Control, on one Record, will be the data that appears in that Control on every Record in the Form...that's how the Access Gnomes work, with Unbound Controls!

    For the Control's data to be Record-specific, you have to do as Bob's response suggested...add a Field to the Form's Record Source and Bind the Control (a Check Box, in this case) to that Field, i.e enter the Field's name in the Control Source of the Checkbox.

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

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

Similar Threads

  1. Checkbox default value problem
    By shod90 in forum Forms
    Replies: 4
    Last Post: 01-10-2016, 02:31 PM
  2. Continuous Form With Checkbox VB Problem
    By WhiskyLima in forum Access
    Replies: 4
    Last Post: 11-25-2013, 08:25 AM
  3. Checkbox problem if Yes or No
    By Amen in forum Access
    Replies: 3
    Last Post: 09-23-2013, 11:54 PM
  4. Problem with my checkbox vba code
    By wrkadri in forum Programming
    Replies: 2
    Last Post: 12-13-2012, 02:12 AM
  5. Checkbox in forms
    By adi.shoukat in forum Forms
    Replies: 1
    Last Post: 03-02-2010, 10:58 AM

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