Default Value on SubForm Tab Page #2 from Main Page Tab #1

[nlsmith326]

Greetings!

Was wondering if anyone out there had any suggestions for setting a default value.

I have one main form w/ tabs & subforms. What I've been trying to do (unsuccessfully ) is set a default value in the subform on one tab as the value provided on the main from on the first tab.

I was able to put this string together, but everytime I check my form, the value doesn't display...

me!contactlocat ion.defaultvalu e = forms!frmMainTa rget!streetaddr ess

Many Thanks,
~Natalie

[ADezii]

Greetings!

Was wondering if anyone out there had any suggestions for setting a default value.

I have one main form w/ tabs & subforms. What I've been trying to do (unsuccessfully ) is set a default value in the subform on one tab as the value provided on the main from on the first tab.

I was able to put this string together, but everytime I check my form, the value doesn't display...

me!contactlocat ion.defaultvalu e = forms!frmMainTa rget!streetaddr ess

Many Thanks,
~Natalie

Assuming you are assigning the Default Value within the correct context, you must use a String expression to set the Value of this Property:
[CODE=vb]Me![contactlocation].DefaultValue = "'" & Forms!frmMainTa rget![streetaddress] & "'"[/CODE]