Calls subform sort on date not contact id

[peter]

using the contact database. Have it replicated so primary
key is now random number. when looking at previous calls
they now are not in any order. the call listing subform
has the master and child fields set to ContactID. If i
change the child to date, the whole thing screws up
(doesnt work properly. How can i get calls to be
displayed in decending order.

 

[Marshall Barton]

using the contact database. Have it replicated so primary
key is now random number. when looking at previous calls
they now are not in any order. the call listing subform
has the master and child fields set to ContactID. If i
change the child to date, the whole thing screws up
(doesnt work properly. How can i get calls to be
displayed in decending order.

Set the subform's record source to a query that sorts the
data in whatever order you want.

 

[John Vinson]

using the contact database. Have it replicated so primary
key is now random number. when looking at previous calls
they now are not in any order. the call listing subform
has the master and child fields set to ContactID. If i
change the child to date, the whole thing screws up
(doesnt work properly. How can i get calls to be
displayed in decending order.

Open the Subform's Recordsource (change it to a query if it isn't
already); put a sort on the desired date field, and save the query.
The subform will then obey the query's sort order.