Search results

By fiddling around I found a solution, but it seems convoluted. Is there a better? Me!cboSelectLeadSource = [cboSelectLeadSource].[ItemData](Left(Right(Me!cboSelectLeadSource.DefaultValue, 2), 1))

Thanks, I just tried FilterOn = false and it works. The command button now clears the filter. But strangely, when I then do a sort of the records by clicking on "Sort A-Z" on the toolbar, the previous filter reappears in the form's filter property. How do I prevent that? It's a problem if a...

Access is slowly beating me down with its virtually useless help information, and I find it very difficult to get the answers through the MS knowledge database. Fortunately, this forum has been quite helpful in overcoming my access frustrations! Enough editorializing. Here is my basic problem...

I've set up a command button to remove the filter that is applied to a form. I used the code from MS article Q208548 that is very simple: Me.Filter = "" However, this does not actually clear the form's filter property (it does, however, display all the records as if the filter property were...

Jack, thanks for the knowledge base article. It helped solve a secondary issue with how to better set up my query in VB. Unfortunately, it did not help with the basic problem of getting the query to evaluate the form reference as Not Like "*" or alternatively Is Null rather than as a string...

Please help with this one: I want a query to run off of criteria supplied by combo boxes on a form. There are seven combo boxes; the user selects values from any or all of the combo boxes, and the query then returns the records matching the user's selection -- at least that is the way I want...