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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

webinsomniac@gmail.com - 13 Jul 2007 23:49 GMT

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

Reply to this Message

tina - 14 Jul 2007 03:48 GMT

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

> Hello,
>
[quoted text clipped - 14 lines]
> Is this even possible with Access? I am using Access 2007, but the
> actual database was created in Access 2000

Reply to this Message

webinsomniac@gmail.com - 14 Jul 2007 06:08 GMT

> answered in microsoft.public.access.forms newsgroup. please don't multipost.
> for more information, seehttp://home.att.net/~california.db/tips.html#aTip10.
[quoted text clipped - 21 lines]
> > Is this even possible with Access? I am using Access 2007, but the
> > actual database was created in Access 2000

My apologies. It wont happen again.

Reply to this Message