Fetch value using an SQL query based on selection of combo box

[Remsky]

I have a subform with 2 fields: Type (=fixed list of 3 types) and Result (which needs to be fetched using SQL).


I have 3 tables: Types (TypeDescription), LookUp (TypeDescription, ResultMatchID) and Results (ResultID, ResultMatchID)
When I select Type A in the forst Combo Box, I want to look for Type A in table LookUp, fetch the corresponding ResultMatchID from that table and look for that value in table Results and fetch the corresponding ResultID. That ResultID is the ID that needs to be used in Combo Box field Results.

SELECT ResultID FROM Results R
INNER JOIN LookUp L ON L.ResultMatchID = R.ResultMatchID
INNER JOIN Types T ON T.TypeDescription = L.TypeDescription
WHERE L.TypeDescription = "Type A"

How can I apply this value to form field Result, when it needs to be updated after changing form field Type?

[ranman256]

WHERE L.TypeDescription = forms!myForm!cboBox

[Remsky]

Thanks for your reply!
Unfortunately I don't know how to add SQL to an event. Can you assist?
And I need to add the result of that query to a different combo box. How to do that?

Sorry if this is a beginner's question...