updating a query

[WaltLukeIII]

i have a query that gets it's information from three different tables. I want to update and change one of the filters on this query with the push of a button. I know that there is an update command but am not sure how to make it work. suggestions are always welcome. <p>Walt III<br><a href=mailto:SAElukewl@netscape.net>SAElukewl@netscape.net</a><br><a href=

http://www.muc.edu/~lukewl>homepage</a><br>

 

[kathryn]

I'm not sure I understand your question.&nbsp;&nbsp;Do you mean that you want to change the criteria for the query?<br><br>When you say &quot;at the push of a button&quot;, do you mean that the query is the basis for a form?<br><br>I hope I can help, but I will need a bit more info.<br><br>Thanks,<br>Kathryn

 

[WaltLukeIII]

I have a form that data is entered into. From that form I want the user to be able to print a report but not all of the data is contained in the form some of the data comes from two other tables. this data does not need to be seen until the printout. I was using a query to bring all of the information together however the form has a filter and I only want to print the information contained in the form with the filter on so. Yes I do mean the criteria of the query. I want to set it to the same thing as the filter I have that piece of information I just don't want to recreate the query everytime the button to print is pushed I just want to requery it.<br> <p>Walt III<br><a href=mailto:SAElukewl@netscape.net>SAElukewl@netscape.net</a><br><a href=

http://www.muc.edu/~lukewl>homepage</a><br>

 

[kathryn]

OK, now I am with you.&nbsp;&nbsp;You want to &quot;refine&quot; your query.&nbsp;&nbsp;How about applying the filter to the report in the Open event of the report?&nbsp;&nbsp;Would that do what you need?<br><br>Kathryn

 

[WaltLukeIII]

Can I have multiple tables represented in a report. If so yes that will work. Can you give me a hint on the code. <p>Walt III<br><a href=mailto:SAElukewl@netscape.net>SAElukewl@netscape.net</a><br><a href=

http://www.muc.edu/~lukewl>homepage</a><br>

 

[kathryn]

Your report can be based on a query so, yes you can have a report based on multiple tables.<br><br>I am late for a meeting, so I can't work on the code right now.&nbsp;&nbsp;Look at the filter property and the filteron property and applyfilter (all in the help files).<br><br>I am tracking this thread, so post if you still need help.&nbsp;&nbsp;I will probably not get back to you until tomorrow.<br><br>Kathryn

 

[WaltLukeIII]

Thank you very much for the advice and help both are greatly appreciated. I did get it to work beautifully. Keep up the good advice. <p>Walt III<br><a href=mailto:SAElukewl@netscape.net>SAElukewl@netscape.net</a><br><a href=

http://www.muc.edu/~lukewl>homepage</a><br>