opening switchboard demands parameter for query within

M

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?
 
J

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top