I've used code similar to the following in the "On Retrieve Spec Open" event for years:
FormFieldValue("Main Form", "Date_entered", 1, "=")

That works great on the main form. I now have a need to do this with subforms, but it doesn't work on subforms.

I can read a value from a subform with @FormFieldValue, but cannot set a value there with FormFieldValue. Here's the actual code I'm using to test with:

var vStr as String

vStr = @LoadRetrieveSpec("Temp")
WriteLn(@FormFieldValue("Checkbook Transactions", "Note", 0))

FormFieldValue("Checkbook Transactions", "Note", 0, "TEST")
WriteLn(@FormFieldValue("Checkbook Transactions", "Note", 0)) 

For testing purposes, the I'm using the "Temp" retrieve spec to put something in the subform Note field, so that I have something to read when @FormFieldValue reads it. That gets displayed in the WriteLn slate. - Works great.
But, when FormFieldValue attempts to set a new value in the subform Note field, and again, @FormFieldValue reads the Note field, it displays the same thing as the first read.

I'm hoping Ray has a solution.

cbislander wrote on Mar 22^nd, 2022 at 12:06pm:

Technically, @LoadRetrieveSpec does return Int, but a String can still receive it. So, it has no bearing on the fact that FormFieldValue fails to populate the subform field.

I normally do use Int like this:
var vNav as Int
vNav = @LoadRetrieveSpec("Recalculate Balance")

But in this case, this was just a test, and I'm not using the value returned from @LoadRetrieveSpec, or testing it for an error, so it doesn't really matter.

I think I know what is going on. Table View subform? You need to use a 1. Form View you can use either a 0 or a 1.

-Ray

Carl Underwood wrote on Mar 22^nd, 2022 at 8:07pm:


Hey Carl,

You may have had something else going on as I made the Gems subform table view and threw it on the 3rd tab in a group and the code still worked just fine, from a button on the parent form or the On Retrieve Spec open event of the Parent Gem Types form. But as long as it's working for you now, awesome. 

-Ray

Carl,

Send me the app as that's not something I have ever seen before.

As for the Widget Defaults, you can do a Search/Replace in the XML file to get rid of them.

-Ray