Ok i want to create a sort filter, I have a sub form that contains data in one of these fields are user names that are assigned to jobs, I want to be able to via a drop down box that is located in the main form to be able to do a sort that will only show the information that I need in the sub form

I.E. Drop down box in the main form contains my name, I click on the drop down box and then I look in the Sub form, all of the jobs assigned to my name is the only ones showing,

I will place what I have got I know it is a mess which I am sorry for.

var vSortList as String
var vSpec as Int
var vTree as Int

// List and Select Sort Options. Get and run saved spec


PopupSelectPosition(4, @XPos(ThisElement), @YPos(ThisElement))

// vSortList = @PopupMenu("Last Name;Birthday;City;Record Date;Salary", "What Do You Want to Sort By?")
vSpec = @LoadSortSpec(By QS0)

vTree = @SelectTreeItem("Plan Tracking log!Plan Tracking Log.!Search Update Menu!Results Commands!Sort")



// Plan Tracking!Forms!Search/Update!Plantrack!Plan Tracking log!Plan Tracking Log.


Please note due to other code, it has to be run in update mode.



Help please.

DrastixNZ


**** One day i want to grow up and be like you ****

Thanks for answering my question, I was thinking along the same lines.

If i can create the drop downs or popups, that will allow  me to recreate the subform that I have with the data I want that would be want i want.

The issue that i have is how do i do that.

Thanks in advance.