Search results for query: *

Ormsk: Thanks for the reply. I'll look into the Instr and let you know how that comes out. As for the wildcard ( * ), when I try to do that, the form still comes back blank. I'm thinking that the BuildWhere function doesn't look for wildcards in the field, but I'm not sure. I suppose there might...

I'm using the BuildWhere code by FancyPrairie. Everything is working except that when I try to find either parts of a field or multiple values in a field, I get a blank screen. The only way out of it is to turn off the filter. Does anybody know of a way that I can adapt the code to search for...

RoyVidar: I do have some combo boxes, which is probably why it's not working. The new record thing would work, except I have 1 field that is an auto number field and I need to be able to fill that in with a WorkOrder number to look up that record. When I try the new record way, [AutoNumber]...

hkaing79: I'm not sure how I would use that, but I did read the information about it in office help and I don't think it will do what I want.

ZmrAbdulla: I check out the faq, but it seems to be for unbound forms. Is there maybe a way I can make the form unbound? TheAceMan1: I changed the line, but I still the the "Cannot assign a value" error. Is it possible to have Access open a seperate instance of the form without any info in any...

Ok, I put that bit of code in as you said, but now I get an error: "Object Required" If I debug the code, it shows that Me(ctrl.Name) = "" is the line giving the error. A note, the form is a bound form (I don't know if that makes a difference or not.) But I do need to keep it that way for the...

I would like to know if there is a way that I can have a button clear all the fields in a form so that a user can fill in the blank fields to be used in a search. Any ideas?

Never mind, stupid error on my part. Thank you for all your help!

Thank you for your help! I seem to have got this part of everything working. Now I can't get the form to show the records that should have been filtered. I just gives me the same form with no information, except what I typed in to filter the form. Any ideas?

Ok, I think I am beginning to understand... I've changed the name of the module and left everything else the same (code). Now I'm getting an error that says: You can't assign a value to this object.

I have a module called "Buildwhere" Also, I noticed that in the me.filter=Buildwhere, I typed it as BuildWhere, but it kept changing it to Buildwhere (with a small w) I changed the name of the module to the same (small w) and I still get the same error.

I'm not sure what you mean. I'm pretty new to this aspect of Access, and I'm not sure what I need to change. This is what I curretly have: Private Sub Command136_Click() Me.Filter = Buildwhere(Me) Me.FilterOn = True End Sub Thank you for your help!

I did what you said there, and I get an error: Compile error: Expected variable or procedure, not module. What am I doing wrong?

Thank you for the help! I've done what you suggested, but I'm not sure what line I would use to set the filter. Everything I've tried I get an error. What command should I use to set the filter? I've tried using docmd.applyfilter and also Me!filter = but I'm not sure what goes after the =. Any...

Thank you for the reply. Ok, I did have an extra copy of it on another command button. I removed it, an now I get the following error: "Compile Error: Invalid Inside Procedure" Any ideas?

I'm trying to use the BuildWhere function by FancyPrairie to filter a form and put the results back into the form (make the recordsource the result of the function) or have a popup using the results. I put the code in the OnClick event of a command button, but I just get an error saying...