Form Query

[dwatt]

I have a form with 3 drop down boxes and a text box

What I want to do is select either one or all three of the drop down boxes and for the text box to update automatically.

I can do this by setting up a query and setting criteria for the drop down boxes. When the query is run I am asked to enter (type in) the parameter value for each and I get the answer automatically...but I want to do this on a form.

Any help greatly appreciated....hope what I have typed is clear.

Cheers
David

 

[Jack Cowley]

Where you can have no criteria or multiple criteria for a query I would suggest you take a look at the method of doing this that you will find here.

hth,
Jack

 

[dwatt]

Jack Cowley,

Afraid I was not able to resolve the problem and cannot understand why not....problems with the SQL structure perhaps....
I found the info from your reference....I do not understand
what "DoCmd.OpenQuery" is doing...(this may be where the problem lies). If I zipped the problem to you could you have a quick look at it....I can understand if you are too busy.

Cheers
David Watt

 

[Jack Cowley]

If your query (your SQL structure) is returning data then that should be OK. As for "DoCmd.OpenQuery" that is the code to run a query. You can send the db but there is no guarantee that I can solve your problem, but I will take a look. Be sure and give the pertinent details so I will understand what it is you are trying to accomplish....

Jack