Results 1 to 4 of 4
  1. 08-20-2024, 02:01 PM #1
    Maxjoo
    Maxjoo is offline Novice
    Windows 11 Office 365
    Join Date
    Jul 2024
    Location
    Carmel, Indiana, USA
    Posts
    18

    Post How to preview a report of a single record using a command button in form?

    Hello, every-1!!!!!!...



    I have a form showing the record(s) for a singular building. I choose the building, and the related record(s) appears on the form, but when I place a command/macro button to show the current record (only one record) on the screen, the preview I get is of all the records related to the building. What can I do to change the report in order to preview/print only the current record? THANK IN ADVANCE!!!!!...
    Reply With Quote Reply With Quote
  2. 08-20-2024, 02:21 PM #2
    Welshgasman
    Welshgasman is online now VIP
    Windows 11 Access 2019
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,555
    Use the Where clause of the OpenReport command.
    https://learn.microsoft.com/en-us/of...cmd.openreport
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
    Reply With Quote Reply With Quote
  3. 08-22-2024, 01:39 PM #3
    Maxjoo
    Maxjoo is offline Novice
    Windows 11 Office 365
    Join Date
    Jul 2024
    Location
    Carmel, Indiana, USA
    Posts
    18
    Hello, Welshgasman!!!!!!...

    Can You elaborate more on your answer? I think I am missing something here...

    Thank You!!!!!
    Reply With Quote Reply With Quote
  4. 08-22-2024, 02:36 PM #4
    Welshgasman
    Welshgasman is online now VIP
    Windows 11 Access 2019
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,555
    See if this video helps.
    https://youtu.be/mz01mDPNQg0?si=pIlFiU3hoh0HZJnQ
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Print Preview Command Button Locks Access
    By DanKoz in forum Access
    Replies: 7
    Last Post: 03-19-2018, 12:34 PM
  2. Print Preview Command Button on Report
    By HeadBanger in forum Reports
    Replies: 2
    Last Post: 03-18-2018, 11:23 PM
  3. Using a form, how to PDF a single record using command button
    By jonrod in forum Forms
    Replies: 6
    Last Post: 12-30-2014, 10:05 PM
  4. Need help with command button to print report of single record
    By nightangel73 in forum Programming
    Replies: 4
    Last Post: 06-27-2014, 08:02 AM
  5. Form Command Button: Add Record, Close Form and Open Report
    By phd4212 in forum Reports
    Replies: 2
    Last Post: 05-11-2012, 11:52 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums