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?
 
Back
Top