Hello,
I hope someone can help.
I cascade the results from a combo box to list box to show the user what reports are available. Some reports require parameters in their queries - these parameters are entered on the form which has the combo box / list box.
How can I prompt the user to enter any missing parameters when they run the report - at present, I get an error message.
I'd like a msgbox which lists all the missing parameters (if possible!)
Thanks for your help - great forum which I have used extensivley to find solutions/ideas when producing my db.
I hope someone can help.
I cascade the results from a combo box to list box to show the user what reports are available. Some reports require parameters in their queries - these parameters are entered on the form which has the combo box / list box.
How can I prompt the user to enter any missing parameters when they run the report - at present, I get an error message.
I'd like a msgbox which lists all the missing parameters (if possible!)
Thanks for your help - great forum which I have used extensivley to find solutions/ideas when producing my db.