Print current record on form into report (1 Viewer)

coolrunner · Jul 1, 2012

Goodday

Ive been reading other threads on this and am failing to work out what im doing wrong.

Im trying to only print the current record on a form into a report

table = tblStation
primary key = StationID (Number)

form name = frmStation
report name = rptStation

I have tried in a button

DoCmd.OpenReport "rptStation", acPreview, , "[StationID]= forms!frmStation![StationID]"

Any Ideas would be great

Cheers

John Big Booty · Jul 1, 2012

Try;

Code:

DoCmd.OpenReport "rptStation", acPreview, , "[StationID]= " & forms!frmStation![StationID]

The following should also work;

Code:

DoCmd.OpenReport "rptStation", acPreview, , "[StationID]= " & Me.StationID

coolrunner · Jul 1, 2012

Cheers for the fast reply

Unfortunately neither of those methods work ever, nothing happens at all once i click the button.

John Big Booty · Jul 1, 2012

The way I would do this is to put the following criteria in the query that is populating your report;

Code:

forms!frmStation!StationID

John Big Booty · Jul 1, 2012

If StationID is a text value rather than numeric you will need the following;

Code:

DoCmd.OpenReport "rptStation", acPreview, , "[StationID]= '" & Me.StationID & "'"

John Big Booty · Jul 1, 2012

... also your form frmStation must be open for this method to work, but I'm assuming you already know that

coolrunner · Jul 2, 2012

None of these methods seem to work, im sadly at a lose

Ive attached the database if your willing to take a look.

John Big Booty · Jul 2, 2012

The problem lies with your report. What you need do is get rid of all the blank pages. Have a look at your DB again, run the report using;

Code:

DoCmd.OpenReport "rptStation", acPreview, , "[StationID]= " & Me.StationID

now scroll through the pages till you find the one that hold the filtered record.

MayaMana · Jul 2, 2012

Is this what you are trying to do?

I changed the report so that it only cycles through the current record, and then I added a where condition on the open report button. Where the query StationID = the form StationID.

coolrunner · Jul 3, 2012

Cheers both of you for your help, set me on the right path, having explain what i was doing wrong was of great help!

imtiazali266 · Jan 23, 2020

i have also the same problem

Print current record on form into report (1 Viewer)

coolrunner

New member

John Big Booty

AWF VIP

coolrunner

New member

John Big Booty

AWF VIP

John Big Booty

AWF VIP

John Big Booty

AWF VIP

coolrunner

New member

Attachments

John Big Booty

AWF VIP

MayaMana

Registered User.

Attachments

coolrunner

New member

imtiazali266

Registered User.

Similar threads

Users who are viewing this thread