is this possible??

[adaniele]

is this form with a query on it possible??

Hi all,
In order to finish my work i need to solve this first.
I would like to create a form where i can show data filtered by multiple fields.
For ex i would like to filter the data by:
Status and/or requester and/or open date and/or description, etc..

any clue?
thx in advance, Max.

 

[adaniele]

improving

this problem is getting better but not enough.
I created a form with 2 unbound fields which will act as filters and a button to apply the filters. Also, i created a query filtered by this 2 fields. Then, in the form when the button is pressed a new form with the result appears.
My question is:
Could i put the result in the same form than the filters?? how??
thx, Max.

 

[adaniele]

i am still trying. what i created works only if i complete both fields in the form. if i leave them in blank it doesnt bring al the data from the table.

suggestions? thx

 

[ThreeCrow]

In each of the Criteria Fields of the Query that you are useing, use the code below.

Like IIf((IsNull([Forms]![FormName].[ComboBoxName]),"*",[Forms]![FormName].[ComboBoxName])

Change the FormName and ComboBoxName to your names.


What this will do is, if the ComboBox is emty (Null) then All records are selected, if not emty than Selected Records are selected.

Hope this helps

 

[adaniele]

threeCrow, thx very much for your help. it works, but i am not using that form anymore. I created a new form from a sample database in microsoft knowledge database.

thx a lot.