I did resolve the "search as you type" problem in the Search Seminar, Lesson 33, which I see you've taken. Is it not working for you?

If you want to work with numeric values, I'd suggest putting a combo box before the search form that has ">", "<", "=", and "<>" as options. Default it to "=". Then you can add this to your search string accordingly.

Not sure if I covered that last one in the seminar, but it's not hard to implement. If you can't figure it out let me know and I can make a TechHelp video about it.

Thanks Rick, I was skimming through that one since it looked similar to the expert class and I missed the couple minutes of discussing the space error, that's fixed now. Thank you!

You do discuss the symbols in a combo box in your seminar, I just wasn't sure if there was a way to let the user type it in and have it work like checking what ASCII value the first character was or something and applying it to the SQL statement then if it was "" or "".

Thank you
Adam

Sure. You can do anything you want. You could give them a text box and let them type in = < > etc. You don't even need to go as far as ASCII values, just do a comparison and see if it's an allowed string.