Results 1 to 2 of 2
  1. #1
    rowardHoark is offline Novice
    Windows XP Access 2003
    Join Date
    Jan 2011
    Posts
    1

    Code to display latest record number field created?


    I need some code to display only the latest "Record number" field from a particular table in a text box, e.g. doCmd...take latest data from a field in table....show in a text box....

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    You haven't said what you have tried already and the results you obtained.

    Suggest you work with the Form wizard just to create a form with a text box.
    And do some test querying to find record numbers, working to get a query that will show the latest (does that mean the highest) record number?


    There are some good free video tutorials at
    http://www.datapigtechnologies.com/AccessMain.htm

    watch a few of these to get comfortable with some Access features.
    Good luck

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

Similar Threads

  1. Replies: 9
    Last Post: 01-06-2011, 01:22 PM
  2. Who created new record
    By ducecoop in forum Access
    Replies: 10
    Last Post: 10-28-2010, 02:50 PM
  3. Replies: 1
    Last Post: 09-21-2010, 09:49 AM
  4. Query latest record
    By asherbear in forum Queries
    Replies: 5
    Last Post: 08-02-2010, 03:58 PM
  5. Replies: 3
    Last Post: 10-23-2009, 05:03 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
  •  
Other Forums: Microsoft Office Forums