User wants filtered records to show current "effective date" first

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that filters by plan and product chosen, then the user clicks
the command button & it opens all forms with the specified plan and product
chosen previously.
The user is ok with this, except that the forms are not in order by
effective date, which they want to see the most current.
Can I set code or rules to that particular text box that has the effective
date to always sort to most current upon opening?
If so, how?
Thank you
 
Mary,
You wrote
the command button & it opens all forms with the specified plan and
product
chosen previously.
Click to expand...
Probably you mean... it opens all "records" involving that plan and product.

If you have a table behind that form, use a query, based on that table,
instead. Then you can sort the query by EffectiveDate Descending, and send
the user to the last record upon opening. That will always open to the
latest EffectiveDate in your recordset.
 
Back
Top