Enter Parameters through a Form

[ericschramm2000]

I've searched the forums for quite a while now and haven't exactly found the answer I'm looking for, so I appologize if it's already been covered elsewhere.

I have a tough situation to explain, but I'll do my best:

I have a query that has several fields that are calculated by adding or multiplying other fields in the same query - a few of which are parameters. I have made the parameters the "right way" by going to the query menu and selecting Parameters... and filling in the neccessary Parameters and Data Types instead of creating a new field in the query and putting my parameter info in that way.

So, long story short. I want to have a form where the user can enter in the parameters, select a value for a field from a drop down box, hit a "go" button and a report will be generated listing info from that query.

How do I go about entering parameters through a form and how do I put in a drop down box that will list all of the values available for a field in the query?

Thanks in advance,
Eric

 

[sam77755]

1. How do I go about entering parameters through a form
2. how do I put in a drop down box that will list all of the values available for a field in the query?

1- there is 2 ways the first is coding it. and the second is to use the query builder to select the fields you are getting the parameters from in the form.

2- it all depends on the values I.E ( small list, large list, static, dynamic) and your options are either create an array with your variables or manually enter them in the ddbox window or create a seperate table to get the vale from.

 

[sam77755]

1. How do I go about entering parameters through a form
2. how do I put in a drop down box that will list all of the values available for a field in the query?

1- there is 2 ways the first is coding it. and the second is to use the query builder to select the fields you are getting the parameters from in the form.

2- it all depends on the values I.E ( small list, large list, static, dynamic) and your options are either create an array with your variables or manually enter them in the ddbox window or create a seperate table to get the vale from.

 

[sam77755]

1. How do I go about entering parameters through a form
2. how do I put in a drop down box that will list all of the values available for a field in the query?

1- there is 2 ways the first is coding it. and the second is to use the query builder to select the fields you are getting the parameters from in the form.

2- it all depends on the values I.E ( small list, large list, static, dynamic) and your options are either create an array with your variables or manually enter them in the ddbox window or create a seperate table to get the vale from.

 

[ericschramm2000]

Can you give me an example of how to go about coding it? I'm very inexperienced with coding.

 

[sam77755]

in that case eric go for the builder.