Search button to filter data

[Emmanuel]

Am trying to create a search button for my data.
The current codes I have makes it possible to filter the data between date range and one drop down selection.

I will like to add one more combo selection to the code to filter.



Below are my current codes:

“ strCriteria = "[MyDate] >= " & Format(Me.OrderDateFrom, "\#mm\/dd\/yyyy\#") & _
" And [MyDate] <= " & Format(Me.OrderDateTo, "\#mm\/dd\/yyyy\#") & _
" AND [IncomeType] LIKE '" & IIf(IsNull(Me.cboIncomeType), "*", Me.cboIncomeType) & "'"
'task = "select * from ALL_INCOME where (" & strCriteria & ") order by [DATE]"
DoCmd.ApplyFilter , strCriteria


Assuming I want to add another combo called “pay_form”, how do I go about that?

[June7]

The same way you added the first combo?

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

[Emmanuel]

The same way you added the first combo?

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

Can you demonstrate for me?
Because I picked the line I used to add the first combo and modified the details to fit the new fields. But the whole line was red, meaning the code is wrong.

Currently having issues with my pc. Would have have copied the codes for you see it yourself.

Would be glad if you could help me out

[June7]

The AllenBrowne tutorial has all the demonstration you should need. Even has a sample db you can download. I am not going to try replicating in this thread.

I have never used the DoCmd.ApplyFilter method.

[Emmanuel]

The AllenBrowne tutorial has all the demonstration you should need. Even has a sample db you can download. I am not going to try replicating in this thread.

I have never used the DoCmd.ApplyFilter method.

Am not so good with the vba that’s why I needed you to help me with the code so I can easily insert them to fix the issue.

Have gone through the link you sent and the understanding isn’t just coming

[Bob Fitz]

Am not so good with the vba that’s why I needed you to help me with the code so I can easily insert them to fix the issue.

Have gone through the link you sent and the understanding isn’t just coming

Can you post a copy of the db

[Emmanuel]

Can you post a copy of the db

That will be a little difficult currently because I have issues with my computer. Will try and upload once I fix it

[Emmanuel]

Whilst I try to upload the database, this is a shot of where I had the error. Any suggestions will be will be appreciated.

[June7]

Missing & _ at end of cboIncomeType line.

[Emmanuel]

Missing & _ at end of cboIncomeType line.

So something like me.cboIncometype1) & _ "'"

If that’s the case, then have tried that already and it didn’t work

[orange]

No. See how the first 3lines of code in your graphic end with & _
Since the line in red (error) is a continuation, then line 3 needs the same & _
Line continuation

You should copy the actual code and paste it here in the forum. I'm not following the logic of your LIKE construct.

[Emmanuel]

No. See how the first 3lines of code in your graphic end with & _
Since the line in red (error) is a continuation, then line 3 needs the same & _
Line continuation

You should copy the actual code and paste it here in the forum. I'm not following the logic of your LIKE construct.

Your suggestion worked
Thanks so much

[Emmanuel]

A having another challenge trying to apply the filter.
Please any suggestions to fix it?

[Emmanuel]

Have been able to find a fix. I noticed the criteria wasn’t set properly. Thanks to you all

[orange]

1. Can you how us the corrected code. It may help someone else.
2. Mark thread solved (see button at top of page)

Glad you found a solution.