Results 1 to 2 of 2
  1. #1
    aligahk06 is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Posts
    94

    How to enable in a Form that shows last record only in

    Dear All,

    is there any option in a form that show last record only while it is in open mode for entry. It doesn't show all records while open the form in entry mode. while navigation it only shows the correspond record.

    Thank you...


    rgds,
    aligahk06

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,430
    short answer is no, there no option to show just the last record (and presumably the row for the new record?).

    Suggest explain what it is you are trying to do - it may be possible to filter the form in some way to display the last record - but 'last' means nothing in databases without an order - which might for example be based on an autonumber or a date/time timestamp field.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 01-20-2020, 10:06 AM
  2. Replies: 7
    Last Post: 09-10-2019, 01:29 PM
  3. Replies: 2
    Last Post: 03-16-2018, 04:04 PM
  4. Replies: 1
    Last Post: 04-11-2015, 10:31 AM
  5. Replies: 2
    Last Post: 07-30-2012, 09:18 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums