Sorting a SubForm

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!!
 
M

Marshall Barton

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate main form from subform record 0
undo sorts button 2
Cannot sort a table containing text 5
Access 2010 DB not fuctional with multiple users 2
Sort form records by field looked up in another table 1
Sort rows in a sub-form 5
VBA code returns no records hwenKey ID is added 14
Sort in VB using a ComboBox Column Other than the Bound Column 4

Top