If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
User wants filtered records to show current "effective date" first
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 |
#2
|
|||
|
|||
User wants filtered records to show current "effective date" first
Mary,
You wrote the command button & it opens all forms with the specified plan and product chosen previously. 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. -- hth Al Camp Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "Mary A Perez" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need to select a certain X records after a query in access | ab | Running & Setting Up Queries | 17 | October 11th, 2005 03:05 PM |
Filtering subform records (datasheet view) after they're already filtered from parent | R. Choate | Using Forms | 3 | September 11th, 2005 08:35 PM |
How do I show all records in from two tables in a make-table query | The parawon | Running & Setting Up Queries | 1 | April 1st, 2005 10:14 PM |
Columns and layout problems | Phil | Setting Up & Running Reports | 4 | August 18th, 2004 01:34 PM |
Data Filter results no longer show # of records in filtered list | Suzan | General Discussion | 17 | August 5th, 2004 08:47 PM |