Hi Alex
Thanks for your mail.
I'm not sure I know by "building the query graphcally".
I've mad a query that does the sorting of the contact dates descending.
I then copy that SQL-code and paste it into the source of the dates field of the Contact sub form.
That doesn't work either.
My SQL looks like this:
SELECT KontaktT.KontaktID, KontaktT.KundeID, KontaktT.Kontaktdato
FROM KontaktT
ORDER BY KontaktT.Kontaktdato DESC

I realize that it's difficult for you to answer something as detailed as this, and if you dont have an answer it's OK with me :-)

Sincerely
Michael

---

Reply from Alex Hedley:

You can build a Query using the Design View where you pull in the table then select the fields you want etc.

Are you setting it on the Forms Record Source or in the actual TextBox?
Set it as the Form and drag on the Field, it will then show the value from the Query.
Or you would need a DLOOKUP for a specific Field