By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,490 Members | 1,789 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,490 IT Pros & Developers. It's quick & easy.

ordering records in a subform by date with most recent first

P: 56
Hi,

I would like to order the records in a subform frmSub by the field 'ReferralDate' (short date) so that the most recent record appears first. I'm sure this must be fairly simple but I can't get it.

thanks
Lucie
Jul 8 '09 #1
Share this Question
Share on Google+
4 Replies


Expert 100+
P: 1,287
You should be able to set this as part of the SQL for the Record Source for the subform. What is the record source now?
Jul 8 '09 #2

mshmyob
Expert 100+
P: 904
Easisest way is to set the ORDERBY property of the subform to your field name. OrderBY Onlaod should be set to YES.

cheers,

@luciegiles
Jul 8 '09 #3

P: 56
@mshmyob
I tried to put something in the Order by property but couldn't get the syntax right - can you give me an example?
Jul 8 '09 #4

P: 56
@ChipR
Yep, that's done it - SQL statement to pull in all fields from associated table (tblClientDetails) sorted by 'ReferralDate' in descending order.

so simple - cheers!
Jul 8 '09 #5

Post your reply

Sign in to post your reply or Sign up for a free account.