Calls subform sort on date not contact id

  • Thread starter Thread starter peter
  • Start date Start date
P

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.
 
peter said:
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.
Click to expand...

Set the subform's record source to a query that sorts the
data in whatever order you want.
 
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.
Click to expand...

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.
 
Back
Top