Query parameter from a form 2

[Aietoe]

I execute a query getting my parameter from a form.

I'm looking for a way to execute my query without any criteria when the parameter box is left blank in the form.

Thanks in advance for your help.

 

[tlbroadbent]

This works though it may be slow for large tables.

Like [forms]![form_name]![Text_box] & "*" Terry

http://members.home.net/tlbroadbent/index.htm

 

[Amiel]

Perhaps something like this...

Sub YourRoutineThatNormallyExecutesQuery()

[red]If [/red]Me![SubjectFormField] = "" then 'its empty !
' execute query that uses no parameters

[red]Else [/red]
' Execute query that uses form parameter.

[red]End If[/red]

End Sub Amiel
amielzz@netscape.net

 

[Aietoe]

Hi Terry

I tried your solution and it worked out very well.

I had to work a little bit on each of my parameter's properties, but it finally did what i was expecting.One query does everything when i tought i had to create many many queries for every combination of parameters.

And even if my tables content over 7 millions records, the execution is not that slow.

Thanks again

Gilles