Results 1 to 5 of 5
  1. #1
    DigitalAdrenaline is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Dec 2012
    Posts
    100

    Need Help With Macro. Go To Last record

    Hi, I've created a table which I've added to a form for entering new data. On the form I have a button that when clicked, will should take me to the last record of the table, but it's not working. Just wondering if someone might have a solution. The Macro I'm using says:

    GoToRecord
    Object: table
    ObjectName: tbleAuthroFirst
    Recrord: Last



    Screen shots attached. Thanks All.

    Click image for larger version. 

Name:	Form_2016.08.20_21h51m14s_002_.png 
Views:	12 
Size:	27.9 KB 
ID:	25524Click image for larger version. 

Name:	Form Edit_2016.08.20_21h51m59s_003_.png 
Views:	12 
Size:	41.1 KB 
ID:	25525Click image for larger version. 

Name:	Macro_2016.08.20_21h50m08s_001_.png 
Views:	12 
Size:	32.7 KB 
ID:	25526

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    I rarely use Macros. However, maybe you could select an object type other than Table and use Child9 as the object name.

  3. #3
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,474
    DoCmd.GoToRecord , "", acLast

  4. #4
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    Quote Originally Posted by Bulzie View Post
    DoCmd.GoToRecord , "", acLast
    As I mentioned, I am not very familiar with Macros. But, I have to wonder if this is relevant.

  5. #5
    WendellS is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    10
    Go to record
    Object type = Form
    Object name = {name of form your working on}
    Record = last

    Basically youre telling the FORM where to go (it's already reading your table info)

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

Similar Threads

  1. Manually record a macro
    By Triscia in forum Macros
    Replies: 3
    Last Post: 09-27-2013, 09:29 AM
  2. Macro to open URL from Field record
    By COiSman in forum Programming
    Replies: 3
    Last Post: 12-26-2011, 02:25 PM
  3. Carry value over to new record w/macro
    By bbrazeau in forum Programming
    Replies: 5
    Last Post: 10-27-2011, 09:00 AM
  4. Updating a record with a value through a macro
    By jlgray0127 in forum Programming
    Replies: 1
    Last Post: 10-06-2011, 02:34 PM
  5. Macro on New Record
    By blue4512 in forum Access
    Replies: 13
    Last Post: 06-09-2011, 10:13 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