sort records on a subform

  • Thread starter Thread starter PMK
  • Start date Start date
P

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!
 
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
 
Back
Top