I just started working on a complicated database that was handed to me after a few people have worked on it. I need to be able to edit a "Work Order" form. The database allows for it to be created, but not edited.
It's created after filling out required information in a "add packets" form. When the work order is created, a macro checks to make sure all the necessary information is in the fields on the add "add packets" form.
Upon making an "edit packet" screen, I am trying to open up the Work Order, but the macro is giving me errors since the "add packets" screen is closed. My thought was to go back to the macro and change it so that if the "add packets" screen was open, it would then check the fields in that form. If that form was not open, then it would check the fields in the "edit packet" form.
MY QUESTION: Does anyone know how to set up a condition on a macro so that it returns either true or false based on if a form is open????
Any help would be appreciated!!! Thank you
It's created after filling out required information in a "add packets" form. When the work order is created, a macro checks to make sure all the necessary information is in the fields on the add "add packets" form.
Upon making an "edit packet" screen, I am trying to open up the Work Order, but the macro is giving me errors since the "add packets" screen is closed. My thought was to go back to the macro and change it so that if the "add packets" screen was open, it would then check the fields in that form. If that form was not open, then it would check the fields in the "edit packet" form.
MY QUESTION: Does anyone know how to set up a condition on a macro so that it returns either true or false based on if a form is open????
Any help would be appreciated!!! Thank you
