Comparing field values to queries

[Guest]

I am currently working on an access database that has 2 fields. They are both
list boxes. I want to compare the first one to a query and have the second
box be directly impacted by the comparison. Any help would be great. Thanks
in advance.

 

[Vincent Johns]

I am currently working on an access database that has 2 fields. They are both
list boxes. I want to compare the first one to a query and have the second
box be directly impacted by the comparison. Any help would be great. Thanks
in advance.

Set up a new Query that uses as data sources both the Table and the
Query whose fields you want to compare. Include both fields in the new
Query. Save the Query.

Then add a field to the new Query that depends on both fields in the way
you want it to. When the Query is working the way you want, use it as
the basis for a Form that includes the list boxes you mentioned.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.