hi all

I have a switchboard (paying attention to Freight History Per Shipper) where the command button runs a macro to open a query. The query will ask for a shipper name (enter joe) which displays the correct info but when I click on the [X] the query keeps asking the same question over and over. I have no problems with other macros cept for this one. If can forward my db is u need to look at it. Thank you all

Zisko

Do not use a macro to open the query. Open the query from the switchboard.



Sal

I would suggest designing a Queries Dialog Box for the purpose of opening queries. You'll need to use an SQL Statement to retrieve the query names from the MsysObjects table as well as VBA code to make the form functional.

Ben Horne
Madison Area Technical College student
-------------------------
http://community.webshots.com/user/valerian114

Go there. I have a lot of awesome photos that I rendered myself