Results 1 to 2 of 2
  1. #1
    Gregory23 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2015
    Posts
    28

    Open new record as Report

    Dear all,



    Would like to check if it is possible to open a new record ID in a table as a Report. Just like Form it will open up a new ID once the code runs

    For example : table has record ID from 001 to 005 but when a new report is open/created there will be a 006 added to the table

    Thank you

    G

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    once the new record is created and saved, THEN you can open a report.

    From the form that made the report,
    docmd.OpenReport rpt,acViewPreview ,,"[recID]=" & txtID

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

Similar Threads

  1. Open Form To Specific Record From A Report?
    By shoelesscraig in forum Reports
    Replies: 6
    Last Post: 12-11-2015, 08:38 PM
  2. open record, attachment from report
    By mibo in forum Reports
    Replies: 1
    Last Post: 11-24-2014, 10:18 AM
  3. Report RecordSource record count at Open
    By GraeagleBill in forum Reports
    Replies: 11
    Last Post: 04-19-2013, 02:03 PM
  4. Replies: 2
    Last Post: 04-02-2013, 02:24 AM
  5. Open Report is opening one record only
    By kelann in forum Reports
    Replies: 4
    Last Post: 10-23-2012, 11:08 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