Switchboard

[carolinera]

Not sure if I'm in the right forum but here goes.

I have a series of reports that work from dynamic queries prompting the user to input the meeting id.

Is it possible from the main switchboard to have a button that says configure database that will then prompt the user for a meeting id that will then, when the user wants to see a report, they are no longer prompted for a meeting id but the report is set to the meeting id number that they input at the switchboard?

I hope that makes sense. Basically I want to eliminate the user having to input the meeting id number everytime they want to see a report. The user would have to use the button on the main switchboard everytime they wanted to see a report.

Thx

- Caroline

 

[carolinera]

Oops...Sorry I meant the user would have to use the button on the main switchboard everytime they started the database if they were to review reports.

The user would not have to use the button on the main switchboard everytime they started the database if they were to input data but only to review reports.

Thx

- Caroline

 

[ColinEssex]

Is there going to be lots of different meeting dates or just one?

Col

 

[carolinera]

Hi Colin,

This group meets three times a year so yes in answer to you question there will be a lot of meeting ids.

- Caroline

 

[Pat Hartman]

Create a form that allows the user to enter the info or select it from combo's. Add a close button to the form (and remove the x so the user HAS to use it). Then rather than closing the form, just hide it. Your queries can then refer tot he fields on this form for their selection criteria rather than prompting. Open the parameter gathering form from a menu button.