Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-24-2013, 10:39 AM   #1
sevanty7
Newly Registered User
 
Join Date: May 2013
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
sevanty7 is on a distinguished road
Opening a Report off of Search Results Report

I currently have a search results Report that displays information from individual records. When someone searches by typing in a description of a record for example the report would show:

Records with related descriptions in a textbox - "Description"
also fields that go along with that related record such as
plan number, file location, physical description

Due to a large amount of records within the database and to make it easier then scrolling through large amounts of records once clients type their search criteria in, I want to have a button beside the record that opens another report that has more fields associated with the record

sevanty7 is offline   Reply With Quote
Old 05-24-2013, 12:51 PM   #2
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 28,249
Thanks: 15
Thanked 1,591 Times in 1,511 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: Opening a Report off of Search Results Report

Do you really mean report rather than form? Reports are "dead" in versions of Access prior to A2007 but from A007 on, click events are recognized.

Just use DoCmd.OpenReport ... or DoCmd.OpenForm .... and use the Where argument to provide the ID of the record you want to open.
__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Old 05-27-2013, 03:38 AM   #3
sevanty7
Newly Registered User
 
Join Date: May 2013
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
sevanty7 is on a distinguished road
Re: Opening a Report off of Search Results Report

What exactly is the where argument?
I have generally no knowledge of using VBA code I'm generally doing everything using macros

sevanty7 is offline   Reply With Quote
Old 05-27-2013, 09:39 PM   #4
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 28,249
Thanks: 15
Thanked 1,591 Times in 1,511 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: Opening a Report off of Search Results Report

If you need help with macros, the macro forum would be more appropriate. The OpenReport/OpenForm Method (VBA) or Action(macro) have a "where" argument. If you type DoCmd.OpenReport in a code module, Access will show you how to complete the remainder of the expression using intellisense as soon as you type the space following the OpenReport (or OpenForm). In a macro, you see all the arguments listed as soon as you select the macro action.

__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Reply

Tags
forms , report within report , reports , searching

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing a report based on the results of a search Rockape Forms 33 06-07-2011 04:13 AM
Hyperlink opening a report from search criteria rasher Forms 2 06-19-2009 12:39 PM
Report output based on search results sokolln Forms 19 08-01-2008 12:37 AM
Report open from form from search results mattloflin Forms 4 12-22-2007 08:58 PM
highlight keywords in search results in report lala Forms 11 02-21-2007 04:29 PM




All times are GMT -8. The time now is 05:09 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World