Report_open

  • Thread starter Thread starter Anon
  • Start date Start date
A

Anon

Private Sub Report_Open(Cancel As Integer)

I would like to set the current record in the table clients to 2 and
open the report with that data.

End Sub

Thank you,
Eric Sepich
(e-mail address removed)
 
To restrict the report to only the record(s) where ClientID is 2:

Private Sub Report_Open(Cancel As Integer)
Me.Filter = "ClientID = 2"
Me.FilterOn = True
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error message 1
Maximize Report 2
Open Date range Dialog Box From Report 2
Bypass Enter Parameter Value 2
show select records in report 1
formatting slq statement to include linefeeds in value returned 12
Records/Forms/Querys 4
Make label invisible 4

Back
Top