Form and queries w/parameters

[Kenln]

I have a query (actually several joined into a single query) that has parameters (actually three parameters in two different joined queries).


I want to base my form on the query but I want to answer the parameter questions programmatically rather than have the user answers.

Can someone please help me with this.

Thank you,

 

[boblarson]

What type of parameters? Normally a form would supply them, so what are you thinking when you say "programmatically?"

 

[KenHigg]

So you don't want to put the values directly in the query because you may want to use the query somewhere else where the values may be different?

 

[Kenln]

The parameters are dates. I would like the form to open and have the user select the date ranges via a calendar control or something similar.

This give me more control and error checking than having the user fill in the default message box that the query would otherwise pop-up.



Any help would be really really appreciated. I could use this in several places.

 

[Kenln]

P.S. Yes I can have the form fill in the parameters for the query.

How would I do that?

Remember....
The source query the form is based on does not have any parameters. Rather two of the queries that are linked in the source query do.

 

[boblarson]

You need to either modify the queries that have the parameter being requested to look to the form or you can remove the parameters completely and then issue the where clause when you need it.

See here for a sample that does the second option:
http://downloads.btabdevelopment.com/Samples/reports/Sample-GenericReport.zip

 

[Kenln]

Thanks Bob,

Let me check these two options.

I have never had a query that existed external from a form refer to a form before. I didn't think of trying that.

Let me check your sample and give both a try.

Thanks again.