Unanswered: script needs input box with multiple controls for user input
I am new to VBScript so please bear with me. I have a script that runs a report and updates a MS Access table. The script uses 6 InputBoxes to get selection criteria from the user. I would like to use a single dialog box for the user to enter the selection criteria. If anyone has experience with this, your advice is welcome. (please include some code if you have a suggestion). To continue, I've designed an Access Form with the thought that the script can open the form, allow the user to enter selection criteria, then save the selections to a single record in the table. Then the script can read that record to get the selection criteria to run the report. However, I need some help with this process from opening the form to having a button to save the selection criteria. Anyway, I have the following code that will not run. Any assistance would be greatly appreciated.
Set cnDB = CreateObject("ADODB.Connection")
cnDB.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"User ID=Admin;Password=;Data Source=" & _
MsgBox "form test complete"