I have a switchboard form with several buttons used to open forms to enter parameters. I'm going crazy with these "parameter" forms.
Ex: The user clicks the "monthly data" button; a form for monthly data appears for them to enter the parameters and click a button to either run the query/report/export.
**I want these forms to open up small, over the main switchboard, and disappear when the query or report is run. I've tried sizing it small, but since the switchboard is set to run full-screen, it changes to full-screen. I've tried saving it as a pop-up, but then the form stays on top when the report/query is run.
I know I can set a popup in the query/report itself to appear immediately to request the input, but in all of my instances, after the user chooses their parameters, they can choose to either run the query, report, or export to excel (from 3 buttons).
So in this case, the button on the switchboard does not run the query/report, but just opens the form for the parameters; then the parameter form option buttons decide which format to run, which the code runs.
HELP! Form sizes have always exasperated me.
Ex: The user clicks the "monthly data" button; a form for monthly data appears for them to enter the parameters and click a button to either run the query/report/export.
**I want these forms to open up small, over the main switchboard, and disappear when the query or report is run. I've tried sizing it small, but since the switchboard is set to run full-screen, it changes to full-screen. I've tried saving it as a pop-up, but then the form stays on top when the report/query is run.
I know I can set a popup in the query/report itself to appear immediately to request the input, but in all of my instances, after the user chooses their parameters, they can choose to either run the query, report, or export to excel (from 3 buttons).
So in this case, the button on the switchboard does not run the query/report, but just opens the form for the parameters; then the parameter form option buttons decide which format to run, which the code runs.
HELP! Form sizes have always exasperated me.
