Permanent filter.

[Indi123]

Hi Guys,
I have a subform with Referral dates of my patients.
At present it looks like this:
Referral Date
11/06/14
16/06/14
30/06/14 (Most newest referral at the bottom)
What I want:
I want the most Newest referral to stay on top
Any advice please
Thanks

 

[BlueIshDan]

What is your form's row source?

 

[GinaWhipp]

You can use a query as the Record Source and add sorting to the date field. Have you tried that?

 

[Indi123]

Hi all

Thanks for reply

My Access knowledge is just above Zero lol
Forms row source ... I assume you are asking where does the form get information from ??

I have two table database (1) Patient Info Table (2) Referral Info Table

One of the field in Referral table is called Referral Date:

Mr Smith can have many referrals, I want the latest referral to stay on Top

What is happening now is: The first referral ..Say it came on 01/06/14 and the latest referral is on 01/07/14....

01/06/14 stays on the top ... I want it other way around

Thanks all

 

[GinaWhipp]

Well, going to need for you to post the Record Source of the Subform.