Issue: I am getting an error message running macros unless I have opened the VBA window at the beginning of a session.
Details: My initial form on start-up (frmMySwitch) has two combo boxes and various command buttons. Most of the buttons use a macro to open another form. Two of them use VBA:
The issues:
Details: My initial form on start-up (frmMySwitch) has two combo boxes and various command buttons. Most of the buttons use a macro to open another form. Two of them use VBA:
- btnStatus saves the selection from cboStatus to openargs and opens frmChecklists. On open frmChecklists uses openargs to apply the appropriate status query.
- btnContact filters frmChecklists by the contact ID in cboContact.
The issues:
- All of the buttons on frmMySwitch work - they open the expected forms. btnContact filters frmChecklists as expected. btnStatus does not apply the query. The form opens to single record, and I can't see any logical reason for it's choice - it's not the first or last record. It's not the record last selected by btnContact.
- The macro buttons on frmChecklist do not work. I get an error message "Object or class does not support the set of events".
- If I open the VBA coding window - the errors all stop; btnStatus filters frmChecklists as expected, the command buttons on frmChecklists all work as expected.