query asking for parmeter twice

[sroot]

I have a database that has a lot of queries that require a parameter to run... The problem is that if you sort it at all from the datasheet it will make you put in the parameter twice. This database is used by a lot of people so there is no use in going in and clearing out the sorts since it will just get sorted again. Is there anything i can do in VBA to delete the sort before the queries are run? Or any other fix i am not thinking of? Thanks for the help!

 

[David R]

Can you set up your parameters on some sort of search form? Then you could reference that form and not have to hand type them each time... it would also let you restrict the values, etc...

 

[nathansav]

or have your first query an append query, and use a dummy table to hold the params then you can refer to them.

 

[David R]

That seems like overkill in most situations. An unbound form acts a bit like a temp table without the overhead.