[Ding_nill]

Hi,

Could someone please tell me how do I combine the following two similar statement into one. They are similar in the sense that they both get input from the same textbox:

Me.ReportsQueryBindingSource.Filter = "ParkingSpaceID = '" & txtSearch.Text & "'"
Me.ReportsQueryBindingSource.Filter = "StudentID = '" & txtSearch.Text & "'"

I have tried couple :
Me.ReportsQueryBindingSource.Filter = "StudentID = '" & txtSearch.Text & "'" Or "ParkingSpaceID ='"& txtSearch.Text & "'"
Me.ReportsQueryBindingSource.Filter = "StudentID Or "ParkingSpaceID ='"& txtSearch.Text & "'"
......just none of them works...

I know there is one way to do it, coz I did it before. But just can't remember it.
Please help

[CharlieMay]

By hilighting .Filter and pressing F1 you should be able to display the help for that property. Here is what I found when I did it

Quote

' The Filter string can include Boolean expressions.
source1.Filter = "artist = 'Dave Matthews' OR cd = 'Tigerlily'"

So maybe try:

Me.ReportsQueryBindingSource.Filter = "ParkingSpaceID = '" & txtSearch.Text & "' OR StudentID = '" & txtSearch.Text & "'"

[Ding_nill]

Thanks to CharlieMay,

I have tried out your suggestion. However, it didn't work out. But I have come up with a 'by pass' solution.

Previously I generate a query to gather info from two tables. And then I try to do a filter through the query. And since the two tables have been combined into a query table, that is why i want to combine the filter statement.

So, now my solution is to go back to the two filter statements which get into from two different tables. (I have not much time left, I still have the time issue to solve)

Anyway, I will come back and post the combined query statement when I figure it out later.