Filtering and creating a report

[richard5150]

Access Version: 2003
OS: Windows XP

I have created 2 tables. The first table includes the students name, students ID and program type (ie: either JD or LLM). The second table includes the students ID, GPA and term year. I have created a query that pulls information from both tables. Works good, no problem there.
What I would like to do is create a form which includes 2 combo box's (1st combo box: program type, 2nd combo box: term year) and create a report with that specific information.
Any help is appreciated!

[NeoPa]

From what detail you've given, I would say build a form bound to the query you mentioned. The report too, should be built on this same query.

[MMcCarthy]

As NeoPa says create the report on the full query.

Then in the code behind the print button (cmdPrint for this example) change it to set a filter as follows:

 
Private Sub cmdPrint_Click()
Dim stDocName As String
Dim stLinkCriteria As String
 
    stDocName = "Report Name"
    stLinkCriteria = "[program type]='" & Me.Combobox1 & "' AND [term year]=" & Me.Combobox2
    DoCmd.OpenReport stDocName, acNormal, , stLinkCriteria
 
End Sub
 
 

I assumed program type was a text field which is why it's enclosed in single quotes and that term year was a number so it's not.

[richard5150]

Thanks guys!!!
all looks good now!

[MMcCarthy]

Thanks guys!!!
all looks good now!

No problem.

Glad it worked out.