Dynamic query in subform

[McShaman]

I am building a form for users to view and filter records.

In the top half of the form I have a heap of text box fields to that allow the user filter by date range or search for text.

In the bottom half I have Subform where I want to list the result of a query basesd on the criteria in the fields above.



My questions are:

1. Can this be done through the GUI or will I need to do something in VBA?
2. Can sombody provide a little guidance as to how I should appoach this?

[June7]

Suggest that a single form will accomplish this. Set form to Continuous view. Put the unbound search controls in the form header section. Arrange data controls in detail section to look like datasheet. Methods to filter will involve VBA, how much depends on approach. Review:

http://www.datapigtechnologies.com/f...tomfilter.html

http://www.allenbrowne.com/ser-62code.html