group check boxes

Question

i have a group with 3 check boxes.the check boxes set a value in records so i can generate a report.

the problem i am having is the last check box selected is not recording to the table or the report. i have to  select some other data input area like another already selected check box or a box that i type in to save the data and put it on the report.

how i generate the report is with a command button using vba to access a query.

Answer 1

Try adding the following line to the event procedure of the command button, above the line that opens the report:

    If Me.Dirty Then Me.Dirty = False

---

Regards, Hans Vogelaar