S
Steve
This is very strange....
Last week I added an unbound checkbox to a form I use to call up a report.
The purpose of the checkbox is to set a preference for the report, when the
report runs I have code in the onformat event to look at the value of the
checkbox and toggle the visibility of two subreports. It worked fine last
week, but now it doesn't. As soon as I check the checkbox, the form starts
behaving strangely. I can still move around in subforms, and enter and
change data, but none of the command buttons work, and the close form (i.e.
'X' button) doesn't work. If I close access, it appears to close but it
won't restart - a check of the process list shows it still running.
I have opened a clean database and imported all the objects I need from the
old database. I have recompiled in code view, deleted any unecessary
references, compacted and repaired, replaced the (*%$^& checkbox, all
various times in various combinations and this bleeper-blanking checkbox
still causes this strange behavior.
Anyone have any idea why? Is there any other way to have a control on this
form to control the report without using a check box?
TIA
Last week I added an unbound checkbox to a form I use to call up a report.
The purpose of the checkbox is to set a preference for the report, when the
report runs I have code in the onformat event to look at the value of the
checkbox and toggle the visibility of two subreports. It worked fine last
week, but now it doesn't. As soon as I check the checkbox, the form starts
behaving strangely. I can still move around in subforms, and enter and
change data, but none of the command buttons work, and the close form (i.e.
'X' button) doesn't work. If I close access, it appears to close but it
won't restart - a check of the process list shows it still running.
I have opened a clean database and imported all the objects I need from the
old database. I have recompiled in code view, deleted any unecessary
references, compacted and repaired, replaced the (*%$^& checkbox, all
various times in various combinations and this bleeper-blanking checkbox
still causes this strange behavior.
Anyone have any idea why? Is there any other way to have a control on this
form to control the report without using a check box?
TIA