Filter Report

[adams.bria]

I have report 1, which gives basic information about job openings, sorted by position, then it lists the employer, # of openings etc.

On report 2 I have the requirements that the employer has sent us.

User would start on report 1, then click button which loads report 2, filtered based on which employer they clicked on.

Problem: How to tell Access to read only the dept which they are clicking on. Right now here is what I have behind the button. It is reading all the dept_name 's except just the dept_name of that specific row.

Private Sub Command41_Click()

Dim dept As String

dept = "dept_name"

DoCmd.OpenReport "rptDept_Requirements", acViewPreview, , dept

End Sub

 

[pbaldy]

Your syntax is off; it looks like this:

http://www.baldyweb.com/wherecondition.htm