Output query data to a field in a form

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Vadimbar (Vadimbar_at_discussions.microsoft.com)
Date: 03/17/05 

Date: Thu, 17 Mar 2005 14:20:29 -0800

Hello, I have a form that holds a drop down box. When I pick an item from
that drop down box it calls a query that looks into another table and outputs
a text value. How do I assign that text value to a text box in my original
form?

original table ==>Cause&Effect_tbl has two fields drop down [Cause] and a
text field called [Effect].
drop down combo box pulls the data from the following table:
Cause=Effect_tble holds two fields [Cause] and [Effect]

Query compares the [Cause] and returns the [Effect]

Hope this is enough info.
Thank you,
Vadimbar