Parameter Query w/params from a form

[raf]

I have a table of all transactions for several products. I want to see just some of them via a form used as follows:

Choose the product via a drop down box.
Enter starting date and ending date in unbound boxes.
Have the selected records show up on a subform.

Can I do this without vba coding?

Thanks - raf

 

[mickeyg]

Sure. Here is my three cents:
1. Create a query with all the fields you want outputted to your form.
2. Create a form and set its record souce to your query.
3. Edit your query to set each field's criteria to your form. For example: the start date's field criteria will be something like Forms!myFormName.myFieldName.

I don't have Access here at work so my syntax is untested and my not be exactly right, but it is a starting point.

Also not sure if any of your form fields are optional. If so you might want to use the "*" within IIF function.

Hope this helps,
Mickey