newbie rerport question

  • Thread starter Thread starter the guy upstairs
  • Start date Start date
T

the guy upstairs

Sorry if this is the wrong place to ask this but I'm in kind of a jam.

Created a form in Access 2K. Saved the form as a report. When I look
at the report I see multiple records. I want to see only one record.
I remember that there is a property that limits this to the active
record only, but can't find it.

Any help would be appreciated.
 
If you're reporting on the current record being displayed on a form, use the value from
that form to filter the report.
If your form had a field called PartNo, you would filter the report query PartNo field
with...
=Forms!frmYourFormName!PartNo
Then the report will only display the PartNo presently on the form.
 
Thanks for your response but I still have problems...
Have a form named prinCurrenttFormm. On that form I have a field
named 'id'
In the filter I've entered '=Forms!prinCurrenttForm!id'

I get a syntax error.
 
I take it you have that in the criteria for ID..

Don't include any quotes... and your spelling is a bit different (Formm vs Form)

Your form must be open when you run the report.

Also, if you're using the query design grid, and the form is open, use the right click
"build" in the criteria to address the value.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions


"the guy upstairs" <.> wrote in message
You also don't need the = sign
 
Back
Top