Searching Form

[ebartlett]

I am making a form to search and I can't get it to work right. I have 8 different Entries in the form and I want to make it so they can search if they only enter say 1-7 the same way they would if they did for 8. The trouble I am having is that when one of the entries is left blank...it will not return any entries. Does anyone know how to make it so if there is nothing entered in the field it will still search right?

 

[ColinEssex]

If you leave the field blank - presumably that means you want records with anything in that field. Therefore in the code can't you add the wildcard "*" if the field on the form is null?

Col

 

[ebartlett]

Can you try to be a little more descriptive here. Are you saying that If I want to be able to leave a field blank then I can't go into the query form where I want it to show up to do the search I can't have any asterists on that one? Is there any way to do it so that I can have asterists if there is something in the field but have it ignore them if it is blank?

 

[ColinEssex]

On the search form you have 8 fields that need to be filled in. If one of the fields is not filled in - then as there is no criteria you presumably want any value that is in that corresponding field in the table. Therefore the search will either be 1) a value that you type in or 2) every value e.g. the wildcard "*"

Col

 

[ebartlett]

So how would I put that into the criteria field correctly?

 

[Birdy]

I have created a search screen before. I will send it to you.

 

[JennJenn]

Birdy, can you send this to me too?

 

[Birdy]

It's on it's way.

 

[ebartlett]

Can you please convert this to a 2000 file and then resend it to me. It will not let me convert it... I don't know if it is my copy that I have at work or what but it is denying me!

 

[Birdy]

Was the form OK for you.