Search results for query: *

I also tried... Me.Filter = "DATATABLE_WHOLESALE.LenderCode = '" & Me.txtLender.Value & "' AND DATATABLE_WHOLESALE.RegionCode = '" & Me.txtRegion.Value & "'" But I get error "2001: You cancelled the previous operation.

Is it possible to have a filter that has more than one value? I cannot figure out how to code it correctly. THe following is what I have for one value. Me.Filter = "DATATABLE.LenderCode = '" & Me.cboLenderCode & "'" I did this for two values but it doesn't work..... Me.Filter =...

By the way I've tried.... Me.cboLender.AddItem ("ALL",0) I get the compile error "Expected: =" ....and I am using Access 2002 if this helps

I have a combo box that pulls the data from a table. Is there anyway for me to add an "ALL" option to the list?

That is what it was. I originally had the fields pulling from a table, then I changed it to a query and didn't change the control source. (DOPE!) Thanks for your help.

I created a form that has two combo boxes at the top. The user has to select a value in each and then click "search". In the code for the button's onClick event I have put me.requery. Right now I have the form's recordsource property set to a query I created and saved in the database that pulls...

Thanks guys, that's pretty much what I ended up doing. Just created a new database and copied the forms in and then I had to rewrite the code.

I created a form and had started the code for it - when I went to save I originally saved it as the default "Form1" Then after I finished the code and wanted to add it to my menu I renamed it to what I wanted it in the forms window. For some reason unkown to me, it renamed it, but then left the...