Sort or Orderby Property?

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

I have a subform with a field of CommentID (this is the
primary key). Ideally, I want this subform to always be
sorted in Descending order by commentID.

I set the Orderby Propery of the subform to
tblComments.CommentID DESC
I also have on the forms load event DoCmd.RunCommand
acCmdSortDescending

At first glance, I thought I was ok. But, if a user goes
and filters the main form, the records in the subform are
not in the desired sort order. The sort order is
sometimes not correct when I go and remocve the filter. I
am a little frustrated here.... is there any way I can
ensure the desired sort order of my subform will occur all
the time....????

I also thought about using the On Current event of my main
form to something like.... (so when a record in the main
form is switched... it resorts the subform)

Forms!frmCommentsSubform.Orderby = tblComments.CommentID,
but this also is not working.

Any help would be appreciated. My users always want the
most recent record on top (Help Desk database)

Thanks in advance.
Don
 
Back
Top