Open Report from Field OnClick

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I really try to do this stuff on my own first. I am trying to open a report
from a field in a form. The field is the autonumber/primary key for the
record. The field is IssID and I tried the following code.

Dim strWhere As Integer

strWhere = Me.IssID
DoCmd.OpenReport "rptIssCheck", acViewPreview, , strWhere

The report opens, but displays every record, all 2355 of them. I really
only want the clicked record to show. Anyone have any tips?
 
You must log in or register to reply here.

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

Opening a Report to a Specific Record 5
Filter Report by Form 2
Adding control to report 1
Report Filter Question 9
Print multiple reports 6
Need a form for Customer Range - can I copy the one I used for dat 1
Use combo to print report between two sets of dates 1
Run select query from VBA code where criteria comes from a multi select ListBox 2

Back
Top