Find/Search is giving me incorrect results!

[imbarney]

I couldn't find an answer in other posts, so please forgive me if this has been discussed before! I"m a photograph and have setup a database of my customers and their orders. I have one field with 4 radio buttons: waiting for payment, not printed, at printer, and printed. Now when I want to see what hasn't been printed, I check the radio of not printed (at one point I was using check boxes and getting the same bad results...but things improved a bit when I switched to radio buttons) and I get the results of what has not been printed with some others that are checked in any of the 3 other radio buttons. I will get the same results every time, until I add new customers or make changes to customers that have gone from printed to printed. To sum up, I get an incorrect find every time!!! Is there a something I'm missing??

Thanks!

[ESpringer]

Gee -- I haven't heard of anything like that and I can't duplicate the problem. Does it happen with "not printed" *only* -- do all the other find requests work? In that case, I'd try changing that radio button (and the values in the records that said "not printed" to "printable" or something like that, and see whether that makes a difference...

Would you be willing to post the file, or a clone without records?

[ESpringer]

One thing I would recommend is not having one radio button be "not" together with the value of another. Although I couldn't duplicate *your* problem, I notice that searching for "printed" yields to "not printed" as well -- because the word "printed" is in there...

[LaRetta]

Hi Imbarney,

It sounds like your existing records (when formatted as checkboxes) have multiple entries in them. Change the field to a standard field and take a look. Make the field large enough to see more than one line. I've done that one myself.

LaRetta

[kenneth2k1]

Very observant, LaRetta! That makes sense.

Barney, What espringer is talking about is true, also. If you search a field formatted as radio buttons, it won't do a literal text search. You would need to use a scripted find, or put that field on the search layout formatted as standard and use "" marks when searching.

Ken

[imbarney]

Espringer...it sounds like your right! I changed everything to "not" include the word not (ie Not printed to "need to print"). So far it seems to work! I just received several orders and will keep an eye out to make sure everything is coming out correct.

Thank you everybody for the reply!

Shawn