Okay, here's the deal.

When I add a new record, any field with "0" (zero) in it is replaced with a blank. In the case of select menus, "---" is selected instead of "0".

It is important that fields with a zero value in them be saved correctly. Otherwise, users will not be able to search for "0". Blank and --- are used as any during searches. I considered using N/A or None but this would further complicate the search process, javascripts, and the general look and feel of the database.

As an example, toys that children ride:
Toy Wheels
pogo-stick........0
unicycle............1
bicycle..............2
tricycle.............3

In this example, 0 is a valid and important value for wheels as related to pogo-stick

So, how do I modify sub validate_record or sub parse_form to prevent 0 from changing to nothing? (Odd question I know, 0 is the mathmatical representation for nothing)

I could really use some help here. Been stuck on this for a week (eternity when setting up a web site).

Thanks,
beetleman

Marcus L. Griswold