print a specific report

[cvolkers]

Looking for the easiest way to do this. When I am looking at a specific record in my form view. Then I click the report button. I would like to have the report (certain data in this report) print to the printer. I just want to have that specific record print, not all the records.

Any help would be great.

[ajetrumpet]

have you ever used the filter property in a report? it's exactly like a where clause in a query statement. when you open your report, what you could possibly do is write something to the effect of:

with me
   .filter = "[recordID] = " & forms("form with the button").controls("recordID")
   .filteron = true
end with

you would still have to print the report manually though. to print it automatically, I believe you have to set the default view to NORMAL instead of PREVIEW.

[Access_Blaster]

Have a look here. http://allenbrowne.com/casu-15.html

[cvolkers]

Thanks all, that did the trick. Now the next question would be. In another program I have a form with a subform in it. I have created a report button for this, but it asks me what the record id for the main form and then the subform id. This gets the correct data from the correct forms.

I used this to do what I needed

If Me.Dirty Then 'Save any edits.
Me.Dirty = False
End If
If Me.NewRecord Then 'Check there is a record to print
MsgBox "Select a record to print"
Else
strWhere = "[ID] = " & Me.[ID]
DoCmd.OpenReport "Special Order Line 1", acViewPreview, , strWhere
End If

I can see that I need to learn a lot more on VB. But is there a way to add to this above for what i am trying to do?

Thanks again.

[cvolkers]

Also I Have a field in one of my forms that has the option "Open" and "Closed" I use to konw how to do this, but now I can't for the life of me remember. I want that field to list Open when I click on a new record. Then when I open this specific form, I would like only the open records to be available.

Thanks.