Can I launch a form from a report?

  • Thread starter Thread starter Jordan
  • Start date Start date
J

Jordan

Hi,

Is it possible to launch a form from a report? I would like my users to be
able to click a record on a report and a specific form pops up.

How can I do this?

Thank You!!!!
 
Hi,

Is it possible to launch a form from a report? I would like my users to be
able to click a record on a report and a specific form pops up.

How can I do this?

Thank You!!!!
Click to expand...

Yes you can open a form from a report using VBA.
No you cannot click on a record in a report and expect it to do
anything. Reports are passive displays of record information. They are
not interactive.
 
Just curious,
We use Peach Tree Accounting and it has the ability to open a form to a
particular record by double clicking on a line of the report.
Example. If you run the report for sales for one day you can double click on
a particular sale and the invoicing form will open to that record.
Any thoughts?
Click to expand...

Just that you're describing a nice feature of Peachtree which is not
implemented in Access. They are different programs with different strengths
and different limitations; this is one of Access' limitations.
 
and How is this done?

Jeff Conrad said:
With the new Report View feature in Access 2007 this is entirely possible.
:-)

--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
Click to expand...
 
Access 2007 introduced a new Report View for reports where you can create
events just like you can for forms. Most of the 2007 templates in Office
Online demonstrate this ability. For example, open the Contacts 2007
template and then take a look at the Contact Phone List report. Switch into
Design View, find the Contact Name text box, and observe there is an
embedded macro in the Click event for this text box. If you examine the
embedded macro steps, you'll notice that it uses the OpenForm action with a
Where clause to open the Contact Details to the matching ID displayed on the
report.

Essentially then you can open the report and then drill into the details of
any contact by clicking this text box. Very slick.

Keep in mind, though, this only works for Report View, not Print Preview.

--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com
 
Back
Top