setting the source or filter on the fly

[Guest]

I would like to know how i can set the filter on a report from a list of
criteria. I have created a report which is executed from a form where a user
can select different criteria. I would like to use the criteria selected as
the filter or maybe the source for the report. How can i past this info from
the form to the report's filter/source.

Thank you.

Andy

 

[Pieter Wijnen]

By Using The WhereCondition

Private Sub CmdReport_Click()
Dim MyFilter As String

MyFilter = "MyField1='" & Me.MyControl1.Value & "'" ' For Text Field
MyFilter = MyFilter & " AND MyField2=" &
Format(Me.MyControl2.Value,"\#yyyy-mm-dd\#") ' For Date Field
MyFilter = " AND MyField3=" & Me.MyControl3.Value ' For Numeric Field
MyFilter = " AND MyField4 Is Null" ' For Null Value, regardless of type

DoCmd.OpenReport "MyReport", acViewPreview, WhereCondition:=MyFilter

HtH

Pieter

 

[Guest]

Hi Andy,

Does this example help?
http://home.comcast.net/~tutorme2/samples/customdialogbox.zip


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Guest]

Thank you, this is exactly what i was looking for.

Thank you for your help and time

Andy

 

[Pieter Wijnen]

de nada

Pieter

Thank you, this is exactly what i was looking for.

Thank you for your help and time

Andy