Okay, this is probably very elementary, but its something i've not picked up yet, and would prefer to know.
Lets say i have a table, Table1, with 3 related values: DataA, DataB, and DataC.
Lets say that I have a form that would display these values as 1 combo box and 2 text boxes.
Combo1 = DataA
Text2 = DataB
Text3 = DataC
If the value in the combo box changes, how could i code the form to automatically prefill (or change) the values from the table in Text2 and Text3 to match the selection of A that was made in the combo box?
Lets say i have a table, Table1, with 3 related values: DataA, DataB, and DataC.
Lets say that I have a form that would display these values as 1 combo box and 2 text boxes.
Combo1 = DataA
Text2 = DataB
Text3 = DataC
If the value in the combo box changes, how could i code the form to automatically prefill (or change) the values from the table in Text2 and Text3 to match the selection of A that was made in the combo box?
