D
DAN
I want to have the date on my subform sorted. I tried to
open the subform and tell it to sort it by the date field
and then close/save it but when I open the main form, it
isn't sorted. Is there a better way to do this. I thought
that I could just write the code to sort it when the main
form was opened but I was wondering what is the code to
do that. In the past I always used:
Forms![Accounts Receivable]![PaymentsReceived
subform]!Date.SetFocus
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 1, 0,
acMenuVer70
But it says that I can't go to the specified record. I am
assuming that is because it is on the subform.
open the subform and tell it to sort it by the date field
and then close/save it but when I open the main form, it
isn't sorted. Is there a better way to do this. I thought
that I could just write the code to sort it when the main
form was opened but I was wondering what is the code to
do that. In the past I always used:
Forms![Accounts Receivable]![PaymentsReceived
subform]!Date.SetFocus
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 1, 0,
acMenuVer70
But it says that I can't go to the specified record. I am
assuming that is because it is on the subform.