Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Help   Contact   Merch   Join   Order   Logon   Forums   
 
Back to Access Forum    Comments List
Upload Images | @Reply | Bookmark | Link | Email | Next Unseen |
Open Report from continuous F
Deborah Longtin 
    
3 years ago
How do I Open a Report to Show a Specific Record from a CONTINUOUS form? I know how to do it from a Single form but am not able to find directions on how to do it from a continuous form.  Richard has provided a great tech help video for the single form using a query.  Guidance please as to how to do it from a Continuous form.  Thank You
Deborah Longtin OP  @Reply  
    
3 years ago
I have found the most excellent video called How to Filter a Report Based on the Filter Set in a Form in Microsoft Access.  That works however, I do not want the user to have to apply the filter.  I would rather they are able to select a record in the continuous list and have the selected record be the filter source for the report filter.  Thank you
Alex Hedley  @Reply  
           
3 years ago
Deborah Longtin OP  @Reply  
    
3 years ago
Hi Alex.  The Open Report video works only with a filtered single form.  I have a continuous form. It needs to stay a continuous form. There are many Minutes Dates with MinutesID. User needs to select record from the continuous form to open the filtered Minutes Report.  Should I be thinking about this differently?  In order to make the report On Open work properly and open only the MinutesR I want, The continuous form needs to be filtered.  I do not want to use the Access filter because the user should not be able to see that.  I want to apply a filter to the continuous form with a control.  Perhaps a combo or list box?  After the record is selected it should apply a filter to list only that record in the continuous form.  Then I hope to be able to open the report as described in the Open Report video.  Thank You
Kevin Yip  @Reply  
     
3 years ago
Add a button on the form's header.  When clicked, have it open the report with the necessary filter based on the selected row's data.  E.g.:

     DoCmd.OpenReport "MyReportName", acViewPreview, , "CustomerID=" & Me.CustomerID
Deborah Longtin OP  @Reply  
    
3 years ago
Thank you Kevin.  The button opens all of the records in the reports.  It does not open the selected report.  Very frustrating.
Kevin Yip  @Reply  
     
3 years ago
Make sure the criteria is a string: note the quotes used in "CustomerID=" & Me.CustomerID.  Make sure Me.CustomerID has a value, which it should on a form with a selected record.  By the way, "CustomerID" is just placeholder for whatever field name is on your form.  If your field is text, add single quotes: "CustomerID='" & Me.CustomerID & "'"
Scott Axton  @Reply  
      
3 years ago
Deborah check out the Open Form video for a refresher.
    Note: In the extended there was / is a glitch in the video. From about :30 to 1:30 another video got compiled into the extended cut for the Snip and Sketch. Just ignore that.

Using the same thought pattern, you can open a Report.  Instead of Docmd.Openform you use .OpenReport
Deborah Longtin OP  @Reply  
    
3 years ago
OMG!!!! It finally worked!!!
Thank You Kevin and Scott!!!!!!!!

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.
 

Next Unseen

 
 
What's This?

 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 11/17/2026 6:11:10 PM. PLT: 1s