Missing check box data in report

[Reaper]

I have a form that has several check boxes which are checked by the user for completed maintenance line items. The form correctly collects the data as can be seen in the table, but the report is not picking them up.



There is a command button on the form to print the report. The report includes the check box fields as well as others, comments, etc. The check boxes all display unchecked, all other fields are displayed correclty. If I close the report and re-open it directly then the data displays correctly.

Anyone ever see this before? Solutions?

[June7]

Could you provide project for analysis?

[Reaper]

A solution came to me overnight that seems to have worked. I added a line in the vba code that goes to a new record just prior to opening the report. I set a variable to the value of the record ID#, go to a new record then open the report using the "Where" clause and the variable.