How do I reset a parameter used in a query

P

PACS

I have a macro that performs a first name search that can be executed from a form. It prompts me for the 'Party First Name to Search For'. It executes the following SQL using applyfilter:

[application number] In (select distinct([application number]) from [application party] where firstname like [Party First Name to Search For]+'*')

It retrieves the correct subset of data.

Then to get back to the whole database I run a macro that does a showallrecords.

It retrieves the complete dataset.

If I try to do the search again I am never prompted and the initial search values are used. How do I get prompted again?

Thanks
 

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

Similar Threads

Need help modifying code 0
How do I set focus (and select text) on a text box on a modeless userform? 0
Extract name, address and ph# 8
How to create portable Excel applications? 2
Using macro to type in parameter values 5
Series of Parameter Queries in Macro 2
How do I clear a form? 0
Office 10 Crosstab query with Parameters 0

Top