A G
asked on
How to order by date in access vba command?
I have the following code
DoCmd.OpenForm "comform", , , "FundName='" & Me.List39.Value & "'", , acDialog
how would I make it so when it opens the form it will sort them by date?
DoCmd.OpenForm "comform", , , "FundName='" & Me.List39.Value & "'", , acDialog
how would I make it so when it opens the form it will sort them by date?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
With als315 comment, you may try this one as well:
Forms!conform.OrderBy = "YourDateField DESC"
Forms!conform.OrderByOn = True
You may use ASC for ascending.
Sincerely,
Ed
Forms!conform.OrderBy = "YourDateField DESC"
Forms!conform.OrderByOn = True
You may use ASC for ascending.
Sincerely,
Ed
Forms!comform.orderby = "ID DESC"
Forms!comform.OrderByOn = True
in "" - field and sequence.