validation rule

HI,
I would like to use a validation rule for a field which would restrict the
values to be entered based on the previous fields combo box selection in my
table. for example if i choose dog in my first combo box, then then i would
like to restrict my next selection in the next field(combo box) to only dog
names. ie.. if field1=dog, then field2="xxx", "yyy","rrr"..

i hope this helps

Sounds like you want to use cascading combo boxes (the source list of the
second depends on the selection in the first). If so, do a search on
cascading comboboxes. There are plenty of posts out there.

Another way would be to use an "If" statement in your source.

Rick B


"atnsx80" wrote in message
...
HI,
I would like to use a validation rule for a field which would restrict the
values to be entered based on the previous fields combo box selection in
my
table. for example if i choose dog in my first combo box, then then i
would
like to restrict my next selection in the next field(combo box) to only
dog
names. ie.. if field1=dog, then field2="xxx", "yyy","rrr"..

i hope this helps

Thanks Rick!

"Rick B" wrote:

Sounds like you want to use cascading combo boxes (the source list of the
second depends on the selection in the first). If so, do a search on
cascading comboboxes. There are plenty of posts out there.

Another way would be to use an "If" statement in your source.

Rick B


"atnsx80" wrote in message
...
HI,
I would like to use a validation rule for a field which would restrict the
values to be entered based on the previous fields combo box selection in
my
table. for example if i choose dog in my first combo box, then then i
would
like to restrict my next selection in the next field(combo box) to only
dog
names. ie.. if field1=dog, then field2="xxx", "yyy","rrr"..

i hope this helps

You posted a "validation" question in a "tablesdbdesign" newsgroup, and
refer to "previous fields combo box selection in my table." My assumption
is that you are working directly in a table, rather than via a form.

Tables are great for storing data, but lousy for displaying it. Rick B's
response about the use of cascading combo boxes works great in forms.

By the way, if you have used a "lookup" data type field in your table
definition, you and other users could end up confused -- lookup data types
are designed to store one value, but display something else. Check this
newsgroup on the topic of "lookup fields", or search Google.com on the same
for further discussion.

--
Good luck

Jeff Boyce
Access MVP

"atnsx80" wrote in message
...
HI,
I would like to use a validation rule for a field which would restrict the
values to be entered based on the previous fields combo box selection in
my
table. for example if i choose dog in my first combo box, then then i
would
like to restrict my next selection in the next field(combo box) to only
dog
names. ie.. if field1=dog, then field2="xxx", "yyy","rrr"..

i hope this helps