Field value, query dependent on two other fields

[pat_nospam]

I have a field which depends on a matrix value from a table, but I'm not quite sure how to populate it.

There are two fields that determine what the third value will be. The form where the two fields are can then match their numbers with an alternate table. My question is, when they match to the alternate table and equal a new number, how can I draw that new number into a field on my alternate form which draws its data from a different table.

So, Table 1 & form 1 determines that Value 1 = 50 and Value 2 = 60.

Table 2 has a matrix which has preset that if Value 1 = 50 and Value 2 = 60, then Value 3 = 33.

How do I put that in an unbound field on my Form to query that Table for a single field answer?

The SQL would be something like "SELECT Value3 FROM tblValueMatrix WHERE Form1!Value1 = 50 AND Form1!Value2 = 60"

Thanks in advance for any pointers,

Pat

 

[pat_nospam]

Correct - my question is, how do I make the field run that query for it's data? I can't seem to get a Textfield to run a query, and when I put a query in it's DefaultValue column, I just get a #Name? return because it returns an array (im assuming).

Thanks again,

Pat