running a parameter query from a simple form

[Dankniseley]

Hi,

I was wondering if it is possible to run a parameter query from a form where the users would simply select the paramters from 3 dropdowns.

Also, I would like the form to do the following. I have a simple query that queries a table of 4 data fields. I want the user to be able to launch the form and select 3 values from 3 different dropdowns. then click a command button and the 3 values from the 3 dropdowns are used as the 3 parameter values.

A sub form could be below the three values but is blank until the 3 dropdown values are selected and the command button is clicked. then returns the query results. This process would be repeated many time by the user. no data would need to be added to the tables.


Any help with this would be great.

Thx

Dan

 

[bat17]

You seem to have outlined quite nicely how to do it

You can create your three dropdowns using the Wizards.
You can use the wizard in the query to set the criteria for the fields.

With your button you will need to requery the sub form.

This is very general so shout if you need more help with the details..

peter

 

[Dankniseley]

I need some steps on how to put the query into the subform.

Currently I have my three dropdowns accessing 3 gifferent tables I want to be able to store the values selected. Then, use thos selected values as my parameters for querying and re-querying.

If you could provide my on the details of how to do this in a simple form
that would be great.

here is an example

Origin port code
1
2

Destination port code
2
1

Service level
1
2
3
4
5

Priority
h
m
l


I want to be able to select one origin port code(dropdown #1)
I want to be able to select one Destination port code(dropdown #2)
I want to be able to select one Service code(dropdown #3)

use these 3 selected values as my parameter and query my full table

ori port code
dest port code
Service lvl
Priority

 

[bat17]

The query for you subform will look like
SELECT tblData.origin, tblData.Destination, tblData.service, tblData.priority
FROM tblData
WHERE (((tblData.origin)=[Forms]![frmFilter]![cbo1]) AND ((tblData.Destination)=[Forms]![frmFilter]![Cbo2]) AND ((tblData.service)=[Forms]![frmFilter]![Cbo3]));

This is assuming that tblData is the table that you want to filter and that the three dropdowns are in a form called frmFilter and called cbo1, cbo2, cbo3.

Once you have your query you can then build a form based on it and drop it into your form with the drop boxes to make the subform.

Assuming that you call this form frmFilterSub then the refresh button will need the code
Me.frmFilterSub.Requery
to refresh the subform


HTH

Peter