I'm in a time crunch and am having trouble figuring out the best way to do this, so hoping for some input.
Here's the scenario: The user goes into the form and needs to select from a list of documents. I originally had the "document needed" in a combobox in a continuous subform so they could select multiple documents. There is a "Notary Required" checkbox. The combobox rowsource changes to show documents that need a notary or those that don't.
If a notary is not needed, they pick their documents and hit Print Preview, and it generates a letter/report requesting those documents. That is working.
If a notary is needed, it needs to generate a different report, list the documents needed with a notary, and also list any other non-notary document needed on an Additional docs needed" line on the report. I have a textbox where they can type in additional documents, but don't like that because they are typing in names of documents.
There are some additional fields that show or hide depending on the document selected and with this continuous form method, the fields weren't working how I wanted when they pick the documents all at once, and then go over to the fields. There are also some other reports that generate depending on the documents selected.
Now I'm playing around with using unbound checkboxes, and having a tab for no notary needed, and a tab for notary and hiding whichever doesn't apply. The notary one lists the other documents also, which would go to the additional docs line. But that seems like a lot of coding when the checkboxes are duplicated for most, and to save all the documents to the table, show and hide fields and produce reports. I don't like either method.
Any ideas on a better way to do this? I only have a couple hours and the pressure makes it difficult for me to think of my options! Thank you!
Here's the scenario: The user goes into the form and needs to select from a list of documents. I originally had the "document needed" in a combobox in a continuous subform so they could select multiple documents. There is a "Notary Required" checkbox. The combobox rowsource changes to show documents that need a notary or those that don't.
If a notary is not needed, they pick their documents and hit Print Preview, and it generates a letter/report requesting those documents. That is working.
If a notary is needed, it needs to generate a different report, list the documents needed with a notary, and also list any other non-notary document needed on an Additional docs needed" line on the report. I have a textbox where they can type in additional documents, but don't like that because they are typing in names of documents.
There are some additional fields that show or hide depending on the document selected and with this continuous form method, the fields weren't working how I wanted when they pick the documents all at once, and then go over to the fields. There are also some other reports that generate depending on the documents selected.
Now I'm playing around with using unbound checkboxes, and having a tab for no notary needed, and a tab for notary and hiding whichever doesn't apply. The notary one lists the other documents also, which would go to the additional docs line. But that seems like a lot of coding when the checkboxes are duplicated for most, and to save all the documents to the table, show and hide fields and produce reports. I don't like either method.
Any ideas on a better way to do this? I only have a couple hours and the pressure makes it difficult for me to think of my options! Thank you!
Last edited:
