Subform ORDER BY

[kutibo]

I have a form that has a subform.

I need to sort the subform by fldDate, a date, not a key, not unique and another field, fldEntryID, which is an integer, not a key, not unique. Currently I'm using the ORDER BY property.

I've made the 2 fields keys and it did not make a difference.

It works correctly when the subform is viewed directly.

It does not work when it is viewed through the master form-it seems to be ordered randomly.

Kutibo

 

[chubby]

If I'm reading you correctly, you need to sort by Field Date and can't. Try using the =Switch() function...