Allen's Browne Search Form modification.

[uhlik]

Hi All,
I would like to make a little modification to Allen's Browne Search Form.

Because I can not add links yet, it is the first Search Form under Applications / Utilities on his excellent website (not "Search As You Type" which I also use with great satisfaction).

So I placed whole Search Form in my form footer.
All I hope to do is put all my continuous form columns to "Type" combo for select suitable column before filtering it.
So all the criteria looks like:
Column / Contains / and possibly Entered Date (From / To).

Thanks for any help in advance.
Regards,
Michał

 

[Uncle Gizmo]

This one?:-

http://allenbrowne.com/ser-62.html

 

[uhlik]

Yes, exactly.

 

[uhlik]

I put here the part contains Combo selection box.
Is there any way to force it to select proper data column in the form before filtering?

'Yes/No field and combo example. If combo is blank or contains "ALL", we do nothing.
    If Me.cboFilterIsCorporate = -1 Then
        strWhere = strWhere & "([IsCorporate] = True) AND "
    ElseIf Me.cboFilterIsCorporate = 0 Then
        strWhere = strWhere & "([IsCorporate] = False) AND "
    End If