[RESOLVED] sorting / filtering a subform

[Shodan]

Hello everyone,
I know this is a simple question. I've don't work with forms and subforms that much but I know this can be done.

Thanks for answering my newbie question.

I have a form "frmResults" that just has a header with a picture and a label.

Attached to it is a subform "subfrmResults" which has a table as the record souce. I basiclly highlighted the table "tblData" and clicked on insert form from the menu item and made it a datasheet form. then I went into the design of "frmResults" and added the "subfrmResults" as a subform.

Now I want to add command buttons in the header of "frmResults" that will sort or "order by", the subform depending on which column the user wants to sort.

I also want to give them the ability to fiter by insurance type or date range when clicking on a button I would pull up an input box so they can type in the date range or insurance type.

For example. The subform's source table and the columns showing on the form are "Insured", "Insurer", "Policy Number", "Start Date", "End Date" and "Insurance Type"

So I will have buttons named as the column headings and when the user clicks on that the subform should refresh the data in the correct sorted order and the lable on the main form "frmResults" should display "Sorted by: " & button clicked.

right now I have this working with a startup form that has the button's on it and when clicked it closes and open the frmResults which has it's record source set to a select query that I created in code. It works fine but the user wants to be able to make changes to the database so I thought instead of having the database table a linked table and using a query to populate the subform I would just import the database into a table and build a form on it and add it as a subform to the main form, create by sorting and filtering buttons and do away with the startup form.

does this make sense??

Shodan