VBA

[Ronald]

Hello,

I am trying to doing something that may not be possible.

I presently have a form for ex: "MAINFORM" that has
several unbound fields (for ex: 'fldHeader' that have
default values in the Control Source (="CompanyName").
Thus the field will show up containing 'CompanyName' .

I want to create another form that if I type a
new "Company Name" I want to be able to take the new value
from this form and insert it to the CONTROL SOURCE of the
field 'fldHeader' in 'MAINFORM'

Is this possible?

Any help you be great.

I hope people can understand what I mean. if not, I will
try and reword it.

Cheers

Ronald

 

[Ken Snell]

Why does it have to be put in the control source? As the control is unbound,
delete the control source expression and just set the value of the control
to the value you want. Much easier to do. You can use the DefaultValue
property to set the initial values that you currently do in the control
source.

You can set the value of the control on the first form in the OnClose event
of the second form.