How to assign a control source to a unbound text box

[Faraa.Oh]

have a form in Access and want to change the control source of a text
box by changing a value in a combo box.

When a selection is made from the combo box, i want to change the
control source of the text box to one of my fields in a table. I
need the control source to the text box to switch between fields
depending on what value is chosen from the combo box.

How do I do this? Please help.

 

[Rui]

you could for example change the "Row Source Type" from the combo box to
"Field List"
Then, still with the combo box, change the "Row Source" to a table that
contains the fields that you want to display and select.

Finally, add and after update event to the combo box and add a line like this:

Me.TextBox.ControlSource = Me.ComboBox.Value

(You should change the Textbox and ComboBox with the name of each control
that you are using).

Rui