unbond text connect with two tables

[dulija]

Hi,

I hope someone will help me with this:
my form has two toggle button and one unbound text box, I want to
connect that unbound text box with some table field when
first toggle button is activated. When I activate second toggle button the
same unbound text box now connect with totaly difference table.

Thank You

 

[MarkK]

To bind a text box to a field you modify the ControlSource property of the text box. It must contain the name of a field that exists in the table or query to which the form is bound.
Question to you: What happens when both toggle buttons are pressed?

 

[Moniker]

Look at the example here. I did it with If/Then statements and not switches so that it was easier to understand.

 

[gemma-the-husky]

having set a controlsource, how do you clear/unset it?

me.controlsource = null?
me.controlsource = nothing?
me.controlsource = vbnullstring?

i couldnt find a way (I may have been trying to change a forms recordsource, but I guess its the same principle)

 

[Moniker]

Me.ControlSource = ""