opening switchboard demands parameter for query within

[Mariah]

Using an unbound form, I set up a switchboard for a membership database that
would streamline some of the regular tasks we complete via command buttons.
Within that switchboard is a command button that prints a report (address
labels) based off a parameter query (for monthly birthday cards).

My problem is that in order to open the switchboard a user must give the
month parameter regardless if they plan to print address labels for the
birthday cards. I would like to only enter the information if we click the
command button to print the cards. Clicking "cancel" causes the whole
switchboard to abort.

Is this fixable?

 

[John W. Vinson]

My problem is that in order to open the switchboard a user must give the
month parameter regardless if they plan to print address labels for the
birthday cards. I would like to only enter the information if we click the
command button to print the cards. Clicking "cancel" causes the whole
switchboard to abort.

I'd suggest putting an unbound textbox on the switchboard (or some other
appropriate form), and use IT as the query parameter:

=[Forms]![NameOfForm]![NameOfControl]

so you don't get prompted at all.

John W. Vinson [MVP]