On the fly researh for report

[Xenocide]

Hi

I'm trying to create a form that, with a on the fly query will show on the report the result of a research the user will have done.

On my report I have a report and a subreport.

For the moment I,m doing my query like that :

...
Else
Select Case Me.opt1.Value
Case 1
strId1 = "Like '*" & txt1.Value & "*'"
End select
End if

strFilter = " [IdEngagementA] " & strId1

With Reports![test1]
.Filter = strFilter
.FilterOn = True
End With
End Sub

The problem is that I can't manage to make a select with condition and toss it to the report and the subreport. I can only do a like which doesn't allow me to choose the data I want correctly. Can someone help me?

 

[snakeyes2002]

Redefine the report's underlying query

all reports i have done are based on queries for a recordsource.

have you tried using vba to redefine the recordsource, either in the report's properties or by deleting, recreating and running the report each time.

SQL: "SELECT ..." "FROM..." "WHERE..." [XXX] Like "'*" & stText & "*'"

did i just confuse you

 

[Xenocide]

actually I tried something like that and it didn't worked