filter report by using a form

  • Thread starter Thread starter Hugo Brouwer
  • Start date Start date
H

Hugo Brouwer

I like to open a report by using a form, on this form i wanted to set a
filter by indepentend pulldown field

One criteria is no problem, but when i have two criteria or pull down field
i get allerts

Dim stDocName As String
Dim stLinkCriteria As String
Dim stLinkCriteria1 As String
Dim stLinkCriteria2 As String

stDocName = Me![Rapportnaam]

stLinkCriteria1 = "[tbl General]![DistributionpanelId]=" &
Me![DistributionpanelId]
stLinkCriteria2 = "[tbl General]![LocationId]=" & Me![LocationId]
stLinkCriteria = stLinkCriteria1 And stLinkCriteria2

DoCmd.OpenReport stDocName, acViewPreview, , stLinkCriteria

Who can solve my problem,

Thanks

Hugo
 
I like to open a report by using a form, on this form i wanted to set a
filter by indepentend pulldown field

One criteria is no problem, but when i have two criteria or pull down field
i get allerts

Dim stDocName As String
Dim stLinkCriteria As String
Dim stLinkCriteria1 As String
Dim stLinkCriteria2 As String

stDocName = Me![Rapportnaam]

stLinkCriteria1 = "[tbl General]![DistributionpanelId]=" &
Me![DistributionpanelId]
stLinkCriteria2 = "[tbl General]![LocationId]=" & Me![LocationId]
stLinkCriteria = stLinkCriteria1 And stLinkCriteria2

DoCmd.OpenReport stDocName, acViewPreview, , stLinkCriteria

Who can solve my problem,

Thanks

Hugo
Click to expand...

stLinkCriteria = stLinkCriteria1 & " And " & stLinkCriteria2
 
Back
Top