Using Data Validation in one column, based on contents of second column

[webinsomniac]

Hello,

This is the first time i've ever posted on this board, so bear with
me. I am trying to add data validation to one column, that checks the
value of another column in the same form, and if the value is true,
not allow a 0 to be entered in the column.

For example, Column 1 = Type, Column 2 = Usage.

If Column1 = Gas, Electric, Water, or Sewer, Then Column2 should not
allow a 0 value. If Column1 = Fire, Garbage, Sanitation Then Column2
should allow a zero value.

Currently my validation is >0 which works, but doesn't filter its
validation based on column1, only on the value of column2.

Is this even possible with Access? I am using Access 2007, but the
actual database was created in Access 2000

 

[tina]

answered in microsoft.public.access.forms newsgroup. please don't multipost.
for more information, see
http://home.att.net/~california.db/tips.html#aTip10.

 

[webinsomniac]

answered in microsoft.public.access.forms newsgroup. please don't multipost.
for more information, seehttp://home.att.net/~california.db/tips.html#aTip10.

My apologies. It wont happen again.