I have a form with a datasheet subform, which contains a combobox of documents to select from. They can add as many documents as they want. 3 of those documents require a notary, 6 do not. If the user chooses a document that requires a notary, Notary Required is automatically checked on the subform and table. If they select, for example, 5 documents, if any one of them requires a notary, I need rptCollLetterNotary to open. If all 5 documents do not need a notary, then rptCollLetter needs to open.
Is it better to check if the checkbox is checked on the form, or to check the table? I'm not very familiar with SQL or Dlookups if that is what I need to do, will need some guidance on that. Thank you!
Is it better to check if the checkbox is checked on the form, or to check the table? I'm not very familiar with SQL or Dlookups if that is what I need to do, will need some guidance on that. Thank you!