Forms to Reports - HELP!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a basic form for entering/editing Workorders, but I have specific Reports based on certain data in the form, i.e, I have a "Store Name" field - There is one (of four) report for each store group

How do I create a button that will look at the "Store Name" on the Form and select the matching report for that Store which has a fieled also called "Store Name". I have tried different VB codes and I must be doing something wrong, it either prints blank reports, all of the data for each record is on one report, or all the data for each record is on all of the reports. HELP!! I really need to get this solved

Thanks in advance to anyone who may be able to help!
 
Hi,

Try something like the following:

Function command1_OnClick()
Dim strReportName As String
strReportName = Forms![name of Form]![Name of textbox control]

DoCmd.OpenReport strReportName, acNormal
End Function

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights


--------------------
| Thread-Topic: Forms to Reports - HELP!!
| thread-index: AcQFaOu1KPk8j6MLTH6YNuWI4r/Hig==
| X-Tomcat-NG: microsoft.public.access.reports
| From: =?Utf-8?B?U2hlcnls?= <[email protected]>
| Subject: Forms to Reports - HELP!!
| Date: Mon, 8 Mar 2004 15:56:06 -0800
| Lines: 6
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.reports
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.reports:132881
| NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
| X-Tomcat-NG: microsoft.public.access.reports
|
| I have a basic form for entering/editing Workorders, but I have specific
Reports based on certain data in the form, i.e, I have a "Store Name" field
- There is one (of four) report for each store group.

How do I create a button that will look at the "Store Name" on the Form and
select the matching report for that Store which has a fieled also called
"Store Name". I have tried different VB codes and I must be doing
something wrong, it either prints blank reports, all of the data for each
record is on one report, or all the data for each record is on all of the
reports. HELP!! I really need to get this solved.

Thanks in advance to anyone who may be able to help!!

|
 
Thank you Eric, I will try your suggestion and hopefully succeed

----- Eric Butts [MSFT] wrote: ----

Hi

Try something like the following

Function command1_OnClick(
Dim strReportName As Strin
strReportName = Forms![name of Form]![Name of textbox control

DoCmd.OpenReport strReportName, acNorma
End Functio

I hope this helps! If you have additional questions on this topic, please
respond back to this posting


Regards

Eric Butt
Microsoft Access Suppor
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026.

This posting is provided "AS IS" with no warranties, and confers no right


-------------------
| Thread-Topic: Forms to Reports - HELP!
| thread-index: AcQFaOu1KPk8j6MLTH6YNuWI4r/Hig=
| X-Tomcat-NG: microsoft.public.access.report
| From: =?Utf-8?B?U2hlcnls?= <[email protected]
| Subject: Forms to Reports - HELP!
| Date: Mon, 8 Mar 2004 15:56:06 -080
| Lines:
| Message-ID: <[email protected]
| MIME-Version: 1.
| Content-Type: text/plain
| charset="Utf-8
| Content-Transfer-Encoding: 7bi
| X-Newsreader: Microsoft CDO for Windows 200
| Content-Class: urn:content-classes:messag
| Importance: norma
| Priority: norma
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.
| Newsgroups: microsoft.public.access.report
| Path: cpmsftngxa06.phx.gb
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.reports:13288
| NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.18
| X-Tomcat-NG: microsoft.public.access.report
|
| I have a basic form for entering/editing Workorders, but I have specific
Reports based on certain data in the form, i.e, I have a "Store Name" field
- There is one (of four) report for each store group

How do I create a button that will look at the "Store Name" on the Form and
select the matching report for that Store which has a fieled also called
"Store Name". I have tried different VB codes and I must be doing
something wrong, it either prints blank reports, all of the data for each
record is on one report, or all the data for each record is on all of the
reports. HELP!! I really need to get this solved

Thanks in advance to anyone who may be able to help!

|
 
Back
Top