Calculated checkbox on form

[justmegan93]

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

[ranman256]

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.