sort records on a subform

[PMK]

That's what I need to know - how to sort records on a subform. I can't
access the subform's orderby property from the main form - probably my
syntax is wrong.

Thanks!

 

[Gina Whipp]

PMK,

You sort the records in a subform by using the RecordSource = Query of the
subform. The main form has nothing to do with the Sort Order or Order By of
the subform. I should mention you can also put something on the On_Open or
On_Current event of the subform but the easiest way is via a Query.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm