Validating Data

[KWhamill]

I'm actually trying to validate the combination of three fields, so that if
field A is something then Field B should be one of these and depending what
combination of A and B I have then Field C should be restricted to this. has
anyone ever done this in a query or is this something I'm going to have to
strike out into VBA for?

 

[Jeff Boyce]

I'm not exactly clear on what (specifically) you're working with. An
example might help.

If you are describing picking a value for fieldA, which then limits choices
for fieldB, which, when chosen, limits choices for fieldC, I believe you are
talking about "cascading comboboxes". Try this as a search term on-line.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[KWhamill]

that's not exactly what i had in mind but that was helpful. No I am importing
or linking to data on a spreadsheet that i need to verify the information on.
I have these three particular fields that are very important. what i want to
do is match what i import or link to a table that contains the right
combination of those three fields and have the query report which rows have
combinations that are not on the list.
I hope this helps

 

[Jeff Boyce]

I'm afraid I don't have a very clear picture yet of what you want to do.

Are you saying that you have three interdependent fields (values in one
depend on another, on another) as input data, and only certain combinations
are valid?

If you have a table of valid combinations, I believe you could use a
"unmatched" query via the query wizard to find records in your import data
that do not match. The query wizard will guide you through setting it up.

Regards

Jeff Boyce
Microsoft Office/Access MVP