Results 1 to 2 of 2
  1. #1
    justmegan93 is offline Novice
    Windows 7 32bit Access 2016
    Join Date
    Jul 2016
    Posts
    8

    Calculated checkbox on form

    Help!

    I have a form which has fields for SPtitle, SPissue and a checkbox (SPcurrentissue) among others



    The titles can be duplicates although will all have different issue numbers e.g.

    Title01 - Issue01
    Title01 - Issue02
    Title02 - Issue01
    Title03 - Issue01
    Title03 - Issue03

    I manually check SPcurrentissue on each record and have created a query to filter the records showing only the current issues which then leads to a report

    Is there a way to automate the checkbox to tick if the record = the current (max) issue of each SPtitle ?

    Hope this makes sense

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,549
    your form has 3 textboxes: txtTitle, txtIssue, txtMax
    the txtMax control source = DMax("[issue]","table","[title]='" & txtTitle & "'")


    the checkbox control source: = txtIssue = txtMax
    this will mark itself when the 2 are equal.

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

Similar Threads

  1. Replies: 3
    Last Post: 04-10-2015, 10:26 PM
  2. Replies: 1
    Last Post: 11-26-2014, 02:30 PM
  3. Form Checkbox Query
    By rlsublime in forum Access
    Replies: 1
    Last Post: 03-12-2012, 12:10 PM
  4. Form Checkbox/combobox help
    By KevinMCB in forum Forms
    Replies: 4
    Last Post: 11-30-2010, 11:05 AM
  5. Disable checkbox on a form
    By caffe in forum Forms
    Replies: 2
    Last Post: 09-16-2010, 07:37 AM

Tags for this Thread

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