Results 1 to 2 of 2
  1. 09-18-2009, 01:45 PM #1
    Fernanvel
    Fernanvel is offline Novice
    Windows XP Access 2003
    Join Date
    Sep 2009
    Posts
    2

    How to navigate trough record by date entered or by key #

    I have a form with about 2000+ record and some how I'm not able to navigate through records by date entered,



    When I tray to navigate through records, they jump from numbers like: record # 205 to 1450 to 1900 etc. I'd like to navigate records by date entered order, using the navigation buttons.

    Please help.
    Reply With Quote Reply With Quote
  2. 09-19-2009, 09:37 AM #2
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Base your form on a query of the table rather than the table and sort on the date.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Populate date from previous record
    By Lianes in forum Access
    Replies: 3
    Last Post: 09-19-2009, 03:42 PM
  2. one date entered to hit 3 fields in one table how?
    By techexpressinc in forum Queries
    Replies: 0
    Last Post: 12-10-2008, 10:43 AM
  3. How can I automatically copy a record entered in one form to another form
    By kabichan in forum Access
    Replies: 0
    Last Post: 11-10-2008, 12:32 PM
  4. Date Stamp On Entry of Record
    By tscholts in forum Forms
    Replies: 3
    Last Post: 04-01-2008, 07:08 PM
  5. Capturing a date when a record has been modified
    By BIG in forum Programming
    Replies: 1
    Last Post: 09-20-2007, 02:56 PM

Tags for this Thread

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