Results 1 to 3 of 3
  1. 03-19-2011, 02:49 PM #1
    newtoAccess
    newtoAccess is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Nov 2009
    Posts
    226

    Auto sort a form when opened?

    I have a nice form that I use to fill a table that works great.


    Is there a way for the form to auto sort F-Name and L_Name fields when it is opened?
    Reply With Quote Reply With Quote
  2. 03-19-2011, 03:05 PM #2
    ssanfu
    ssanfu is offline Master of Nothing
    Windows 2K Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Use a query for the form record source instead of a table. In a query, you can select the fields you want to sort by.
    Last edited by ssanfu; 03-19-2011 at 03:06 PM. Reason: wording
    Reply With Quote Reply With Quote
  3. 03-19-2011, 03:22 PM #3
    newtoAccess
    newtoAccess is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Nov 2009
    Posts
    226
    That works,

    thanks
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Can not close pop up form after second pop was opened
    By snoopy2003 in forum Programming
    Replies: 2
    Last Post: 03-09-2011, 02:56 AM
  2. Report Based on Form - Sort
    By jeffyyy in forum Reports
    Replies: 1
    Last Post: 10-16-2010, 06:15 PM
  3. Sort oldest to newest on form
    By Desstro in forum Forms
    Replies: 6
    Last Post: 09-18-2010, 05:35 AM
  4. Check if form is opened by other users
    By ser01 in forum Programming
    Replies: 2
    Last Post: 05-03-2010, 12:07 AM
  5. Access 2003, sort order property of a form
    By Rick West in forum Forms
    Replies: 11
    Last Post: 09-17-2009, 08:28 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums