Attaching a Command Button to a Query?

[DaveHam]

I currently have a command button on a switchboard that sends an e-mail with a query as an attachment.  The problem is that the query has parameters that have to be entered before it will open, so when I click the e-mail button, it prompts me for the parameters even though the query has already been run and is open.  Is there any way to put the command button directly in the query?  Or can the parameter prompt be removed?  Thanks for the help!

 

[DougP]

No way to put a command button in a query.<br>but yes you can remove the Parameter... but you will also lose the criteria when you do that. Say your query asked for last name and you typed in Smith then 12 records show up.<br>Now if you remove the parameter then every record will show (you will lose your criteria). not just Smiths or Jones or what ever you keyed in.<br>Another way for a query to get criteria is from a form.<br><br>I've not tried to e-mail anything that prompted for input. So I don't know what the solution would be. But you could try using a form where your query looked instead of prompting, or make a report based on the query and e-mail that instead. <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.