Textbox help

[LB79]

Hello,

Could someone please advise me on this problem.
I have a txtbox on a form that I want to change the name of (the VBA isn't in the same form).
I've tried the below options but none work – I've tried DefaultValue and ControlSource.

Thanks for any advice.


[Forms]![MyForm]![TextBox1].DefaultValue = "=MyText”
[Forms]![MyForm]![TextBox1].DefaultValue = "MyText”
[Forms]![MyForm]![TextBox1].DefaultValue = "’=MyText’”

 

[DCrake]

If I understand you correctly you want to pass a value from one form to another. If so, you can use

Forms("OtherFormName")("OtherControlName").DefaultValue = "Fred"

This is called form the form that has the current focus. The Other form must also be open. You cannot pass anything to a closed form.

 

[xarxas]

Hello,

Could someone please advise me on this problem.
I have a txtbox on a form that I want to change the name of (the VBA isn't in the same form).
I've tried the below options but none work – I've tried DefaultValue and ControlSource.

Thanks for any advice.


[Forms]![MyForm]![TextBox1].DefaultValue = "=MyText”
[Forms]![MyForm]![TextBox1].DefaultValue = "MyText”
[Forms]![MyForm]![TextBox1].DefaultValue = "’=MyText’”

you can try [Forms]![MyForm]![TextBox1].Value = "MyText”

 

[LB79]

[Forms]![MyForm]![TextBox1].Value = "MyText”

.value! Of course! How did I miss that!

Thanks for pointing out the obvious!

 

[xarxas]

.value! Of course! How did I miss that!

Thanks for pointing out the obvious!

Glad i can help