Filter Report to Only Print Current Record from Form

[Glenn Zamora]

I am new to MS Access. I have created a simple entry form to track
patient information. I have also created a Patient Report that prints
Patient Information with a standard disclaimer statement. I added a
print button to my entry form hoping that the patient information that I
enter will merge with the Patient Report however I must be missing a
step because when I click on the print button it prints all patients in
the database. Is there a way to filter the report so that it will only
print the current patient?
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[fredg]

On 30 Dec 2004 16:15:28 -0600, Glenn Zamora wrote:

I am new to MS Access. I have created a simple entry form to track
patient information. I have also created a Patient Report that prints
Patient Information with a standard disclaimer statement. I added a
print button to my entry form hoping that the patient information that I
enter will merge with the Patient Report however I must be missing a
step because when I click on the print button it prints all patients in
the database. Is there a way to filter the report so that it will only
print the current patient?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Every patient has his/her own unique ID, correct?
Code the print button's click event:
DoCmd.OpenRepor t "ReportName",ac ViewPreview, , "[ID] = " & Me![ID]

The above assumes the [ID] is a number datatype.

If [ID] is a Text datatype, then use:
"[ID] = '" & Me![ID] & "'"

Change [ID] to whatever the actual name of that unique field is.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

[Rick Brandt]

Glenn Zamora wrote:

I am new to MS Access. I have created a simple entry form to track
patient information. I have also created a Patient Report that prints
Patient Information with a standard disclaimer statement. I added a
print button to my entry form hoping that the patient information
that I enter will merge with the Patient Report however I must be
missing a step because when I click on the print button it prints all
patients in the database. Is there a way to filter the report so that
it will only print the current patient?
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Your print button is using the DoCmd.OpenRepor t method and that method has an
optional WHERE argument where you can apply a filter to the report as it is
opened. You just need to pass in the Primary Key value on your form to that
argument.

DoCmd.OpenRepor t "ReportName",,, "PatientNum ber = " & Me.PatientNumbe r
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Phil Stanton]

In the query on which your report is based, you need to set in the criteria
column for PatientID

[forms]![Patients]![PatientID]

This will restrict the query to showing only records of the patient
displayed on your form. You may also, depending on the information on your
report have to put in a further criteria to restrict the report even more
such as a date.

HTH

Phil
"Glenn Zamora" <gl**********@h chd.tmc.edu> wrote in message
news:41******** **@127.0.0.1...

I am new to MS Access. I have created a simple entry form to track
patient information. I have also created a Patient Report that prints
Patient Information with a standard disclaimer statement. I added a
print button to my entry form hoping that the patient information that I
enter will merge with the Patient Report however I must be missing a
step because when I click on the print button it prints all patients in
the database. Is there a way to filter the report so that it will only
print the current patient?
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!