Using default value in form property if other form not open

[Jan van Bekkum]

I want to fill a property in a form with [Forms]![Opportunities]![Proposals].[Form]![SalesForceNumber] if the [Proposals] form is open and with 0 otherwise. Setting a default value for the property works well if the form is open, but I get (of course) #Name? if the form is not open. How can I enter 0 as default value for the property in that situation?

 

[pbaldy]

Use the current event of the form, test for NewRecord, use IsLoaded to test to see if the other form is open, and an If/Then block to set the value appropriately.