Filtering a subform the *right* way (1 Viewer)

[hokiewalrus]

I currently have a main form and subform about a work ticket, the main containing the header and sub containing the lines.

The two are linked via the ticket number and everything is cool, but they want to be able to filter the lines based on status.

What is the *right* (I know there are probably several ways to do this) to filter the subform? Use the filter property or requery the subform based on the status they want to see?

The tables are linked via SQL and I'm trying to keep the overhead down as much as possible. I'm sure both ways will work, but which way is better?

For informational purposes: The main form's source is tTicketHeader and the subform's is tTicketDetails. The main form is opened with a where condition and the two forms are linked via the ticket number as I said.

 

[Simon_MT]

Try this:

This does work!

Put the Header information is the header section of the Form and the line information into the Detail. No subform is required. You can then filter the information to your hearts content!

Simon