Terrible title, I don't know how to describe it! I have a form that the user completes to create a report. This report is a letter that is sent to the customer asking them to provide a document. There is a multi select listbox with 10 options for the user to choose what they need. The ID of whatever they pick is added to a table and shows in the middle of the report in a subreport. The listbox is based on a table with 3 fields: ID, listbox text, and the longer text that actually appears on the report. Example: Listbox = Name change / Report text = "Please send us a completed name change form." This is all working fine. But now they want to add a couple options to the listbox that require user input, like the following:
Listbox = Licensing Agency
Report text = Please contact the (agency name) Licensing Agency to pay the required taxes.
I have a field for agency name, but I don't know how to put that info into the report with the way it's currently set up. Any ideas on how best to achieve that?
Listbox = Licensing Agency
Report text = Please contact the (agency name) Licensing Agency to pay the required taxes.
I have a field for agency name, but I don't know how to put that info into the report with the way it's currently set up. Any ideas on how best to achieve that?
Last edited: