How to open a report with a determine field (primary key)

[erick-flores]

Hello, I want to make a report for a single compressor. Instead of
showing a report for all the compressors. I would like to place a
button in the compressor form, so whenever I want to display a report
from that particular compressor I click the button and the report will
show ONLY that compressor. Each compressor has it own primary key. So i
guess I need to match that pk with my report. Can somebody give me some
ideas ? I am pretty familiar creating reports but I just dont know how
to create a report for a particular data in a particular field

Thankssss

[Bob Quintal]

"erick-flores" <ch**********@hotmail.comwrote in
news:11*********************@s13g2000cwa.googlegro ups.com:

Hello, I want to make a report for a single compressor.
Instead of showing a report for all the compressors. I would
like to place a button in the compressor form, so whenever I
want to display a report from that particular compressor I
click the button and the report will show ONLY that
compressor. Each compressor has it own primary key. So i guess
I need to match that pk with my report. Can somebody give me
some ideas ? I am pretty familiar creating reports but I just
dont know how to create a report for a particular data in a
particular field

Thankssss

you can open any report filtered to any expression using the
where parameter of the .openreport method of Docmd

in the OnClick event of the button that opens the form,

Dim stDocName as string
Dim stwhereclause as string

stdocname = "myReport"
stwhereclause = "primaryKey = " & me.txtPrimaryKey
docmd.openreport stdocname,,,stwhereclause

The Wizard does the same thing.
--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

[erick-flores]

Got it thankss

[erick-flores]

Hello

OK now, I realize it is showing all the records after the primary key
of the compressor. I though it was going to take only the records
related to that primary key. What I mean is:
Compressor-->Stages-->Cylinders-->Gaskets.... the compressor primary
works fine it shows only the one that is currently displaying on the
form but then it shows all the stages for all the compressors and all
the cylinders for all the compressors and so forth. Is there a way to
link all the records so that only shows one compressor, only the stages
for that compressor, only the cylinders for that compressor, only the
gaskets for that compressor and so on. Any ideas?

Thanks

[Larry Linson]

If your Tables are properly designed and your Report is properly Grouped by
Compressor, selecting the specific CompressorID should give you what you
want. Maybe if you were to clarify your Table / data layout, and some
details on how you created the Report, someone could offer useful
suggestions.

Larry Linson
Microsoft Access MVP

"erick-flores" <ch**********@hotmail.comwrote in message
news:11**********************@75g2000cwc.googlegro ups.com...

>
Hello

OK now, I realize it is showing all the records after the primary key
of the compressor. I though it was going to take only the records
related to that primary key. What I mean is:
Compressor-->Stages-->Cylinders-->Gaskets.... the compressor primary
works fine it shows only the one that is currently displaying on the
form but then it shows all the stages for all the compressors and all
the cylinders for all the compressors and so forth. Is there a way to
link all the records so that only shows one compressor, only the stages
for that compressor, only the cylinders for that compressor, only the
gaskets for that compressor and so on. Any ideas?

Thanks

[David W. Fenton]

"erick-flores" <ch**********@hotmail.comwrote in
news:11**********************@75g2000cwc.googlegro ups.com:

OK now, I realize it is showing all the records after the primary
key of the compressor. I though it was going to take only the
records related to that primary key. What I mean is:
Compressor-->Stages-->Cylinders-->Gaskets.... the compressor
primary works fine it shows only the one that is currently
displaying on the form but then it shows all the stages for all
the compressors and all the cylinders for all the compressors and
so forth. Is there a way to link all the records so that only
shows one compressor, only the stages for that compressor, only
the cylinders for that compressor, only the gaskets for that
compressor and so on. Any ideas?

Sounds like you have subreports on your main report that are not
filtered by the link properties.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

[erick-flores]

I checked my grouping and the problem was in there, thanks