Search results

Oh it doesn't like the Me. part in this line - If Not IsNull(Me.cboOPOwner) Then

Hi Old Man Devin, I a have followed your procedure as below :- If Not IsNull(Me.cboOPOwner) Then If Me.Form.Filter = "" Then Me.Form.Filter = "OPOwner ='" & Me.cboOPOwner & "'" Else Me.Form.Filter = Me.Form.Filter & " and OPOwner = '" & Me.cboOPOwner & "'" End If End If...

In fact I've changed it to 3 characters in the VBA code because it doesn't work anymore for some reason when adding a space to a postcode that has 2-3 characters, sometimes you have to log out of the whole database and go back in and it might work once? When the form after procedure pops up it...

Sometimes it work with a space most of the time. The reason behind the method is when agents call say London we give them a postal area to call so that other agents won't clash or duplicate on calls. I'm not sure how to perform a Public Sub in a new module with above code as it won't let me?

But the only problem as you mentioned is that you can only filter if only you enter the number of characters that are set in the VBA code, so in effect I can only ever enter SW11 which will work, however if I enter SW2 it will not work. :) :) :)

Works a treat thank you so much :) :) The only thing I changed was ,2 and replaced it with ,4 so that I can search on the 1st 4 characters of a post code. but works a treat!! And is it a standard rule that once you have filtered what you want - if say Neil, Pipeline, City, PostCode and if I...

Yep tried the 'LIKE' and the results are the same unfortunately - no results. Even if I put the full PostCode in, it still filters with no results.?

I mean it filters and returns nothing, when you click on the drop down arrow on the combo box all PostCodes are listed in the drop down. When I type SW for SW London and then press enter it filters but with no results. And yes the filter box does show orange and that it has been filtered.

I've tried the spaces in Row Source and it still does the same when I filter OPOwner, Status, City then PostCcode it filters nothing. So yes it does compile with no error's, just no results. All other combo box's work fine. So I am at a loss now as it should work. :(

Cool! OK, Using a space or not between the and hadn't made no difference before, however I have now put in apostrophe and it does filter, but shows not results? Before when adding * it wouldn't run and came up with a compile error suggesting I write Text. = "M16" or syntext error. In the Row...

And it come up with 'compile error'

Would it have anything to do with what I should put in Row Source and Row Source type? in Data on the property sheet.

Would this work only with a text box or combo box, I have tried both & "*" & * & "*" and it's not working. :confused:

Cool thanks where do I put the "*" in my code. Private Sub cboPostCode_AfterUpdate() If Nz(Me.cboPostCode.Text) = "" Then Me.Form.Filter = "" Me.FilterOn = False ElseIf Me.cboPostCode.ListIndex <> -1 Then Me.Form.Filter = Me.Form.Filter & "and [PostCode] = '" & _...

2 things I wanted to ask and I will leave you alone Old Man Devin. In my PostCode combo I want to type in a PostCod that searches post code, however I want to just type in the first part say like 'S' or 'SW' or 'M16' at the moment it will just filter one post code, can I add a wild card to it...

I forgot to ask, would this be the same principle if I had a combo box for say 'City' and then 'Postcode' ?? Cheers

THANK YOU SOOOOOOOOOOOOOOOO MUCH!!!! You have saved my life!!! it works a treat.:D:D:D:D:D:D:D:D:D

Good day! I have at present 2 combo box's that filter, now....... the 1st combo box is a drop down value list that will filter the OPOwner (persons name) for example there are 3000 records and 5 OPOwners, I can for now filter my name in cboOPOwner combo box. The 2nd box (drop down list) is...