Custom sorting a form based on another form

[jlgray0127]

I have a form with 9 different fields I want to be able to sort against.
I have another form, which contains the conditions I need to be able to sort by. I somehow need to be able to say field 1, if value is = to field Form!AnotherForm!Criteria, sort by Form!AnotherForm!SortOrder

Clear as mud?

Basically, My main form has a value for these fields, which equals the criteria listed listed in the other form.

So my sort button needs to be something like, where "MainForm!Field1 = Anotherform!Criteria, Sort MainFrom!Field1 by Anotherform!SortOrder



The Sort Order needs to be able to be adjusted, depending on the data we are analyzing... I wish we could just filter, but that is not the case, we have to see it in order.

If there is another easier way, that is just not coming to me, to be able to do this, that would be great! I don't know how to relate the tables in the back ground, because there are 9 fields we have to be able to look at and sort, so it's a MANY, MANY (9) to one relationship, which always seems buggy or just doesn't work...

Thanks, in advance!

[pbaldy]

You can manipulate the record source of the form, setting it to SQL with the appropriate sort. You can also set the Order By property to the desired field name.