W
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
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