Sorting a SubForm

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

I have a "Datasheet" subform in a regular form. Now this
Datatsheet form sorts properly if I open it directly,
however it is not sorting when displayed as a Sub Form in
my other form. It is sorting it in the order the records
were entered (Primary Key) not by the Lookup Name as it
does when opened directly. Any ideas?

THANK YOU!!
 
Jason said:
I have a "Datasheet" subform in a regular form. Now this
Datatsheet form sorts properly if I open it directly,
however it is not sorting when displayed as a Sub Form in
my other form. It is sorting it in the order the records
were entered (Primary Key) not by the Lookup Name as it
does when opened directly. Any ideas?
Click to expand...

Use a query for the subform's record source.
 
Back
Top