Hi Rick
I have a subform in a parent form, which calls another form.  The form when loaded has a textbox which gets it's default value from the subform.
The default value is set to =[Forms]![EntityTestF]![AddressF].[Form]![PostCodeLookup], which works.  I tested this in a normal parent/child form.
However, i am loading the subform, into the parent form by setting the source object, using a button on click command - SubformControl.SourceObject = "AddressF" [with the form named "SubformControl".
Now the default value will not load in the form - #Name? pops up, which tells me it can not find the field.
It would seem i am missing a step on the route, any help would be appreciated.
Kind regards
John