Passing parameters to queries

[Howie Jones]

Me again

I have a situation where I run a query, carry out some editing on one of the fileds in the query and then run a report based on the query. No problems.

I now need to add a critrion to one of the fields in the query to drill-down further. Again this is not a problem, but the report is also based on the query so the criterion is asked for twice.

I would like the criterion to be enterd only once, which I can do using Criterion=InputBox. But how can I then pass this to the query? I've tried declaring Criterion as Public, but this doesn't seem to work.

Any offers?

HowieJ

 

[namliam]

Read this and see if you can figure it from there?!

Regards

The Mailman

 

[Rich]

You could also just use a popup form to enter the parameters

 

[Howie Jones]

Yes, I think that might be a shorter method than the first one.

HowieJ