Hi all! Hope someone can help me with a problem that has gotten me stumped. I have a form (Main) that contains a multi-valued field/control. This multi-valued field/control gets its choices from a different table. Also in this form is a button (Print Report) that users click to print a report. In this form, if a certain field/control has a certain value then, when the button is clicked to print, certain field/control data is carried over to a new record, so users don't have to retype this data. The data in the multi-valued field (a combobox) is one that I want to carry over, but it doesn't seem to be able to do so. The button to print will not work either if any value is in the multi-valued field/control. I don't know how to solve this.
So I tried a different approach. Currently, I have another button in Main form that will open a different form (Select FR) with the multi-valued list. This form has a button (OK) that will import the selections into the Main form/record into a textbox. This approach doesn't work either.
I have worked to solve this for several months with no luck. Hope someone can get this to work.
I have attached a scaled down version of the database for anyone to use and see what they can come up with to solve the problem. Any help is much appreciated!
So I tried a different approach. Currently, I have another button in Main form that will open a different form (Select FR) with the multi-valued list. This form has a button (OK) that will import the selections into the Main form/record into a textbox. This approach doesn't work either.
I have worked to solve this for several months with no luck. Hope someone can get this to work.
I have attached a scaled down version of the database for anyone to use and see what they can come up with to solve the problem. Any help is much appreciated!
