Avoid @Command([RefreshHideFormulas]) after opening a new form?

Hello,

I have a form with a computed for display field.

Formula: @If(@IsMember(“[debugging]”;@UserRoles);@False;@True)

All lines (fields) on subforms are hidden after opening the form.

The lines (fields) on the basic form are shown, even the line with the hide when field.

All works fine when I use @Command([RefreshHideFormulas]) in the Postopen event.

Unfortuneatly this does not work on the web.

I am looking for a way, without RefreshHideFoermulas.

I do not understand, why it does not work. I thought the form execution order is from left to the right…

Thank you in advance…

Regards

Ingo

Subject: Avoid @Command([RefreshHideFormulas]) after opening a new form?

This is even less critical on the web, since all computations have been completed, before the site is rendered to HTML.

However, in the first place you really shouldn’t have the problem. Looks to me, like the form is corrupt. Try to create a new one and copy over the elements line by line.

Btw., I don’t remember from your original posting, if your Hide field was a number field, but it should be, of course.

Subject: RE: Avoid @Command([RefreshHideFormulas]) after opening a new form?

Thank you for your help. Unfortunately I am running out of time. I set all hide formula to 1.

As soon as I have more time I will try your suggestions.

In my opinion it has something to do with form / subform relationship.

Strangely all hide formulas on the subform are working fine.

The issues are on the form.

Thanks again - for your interest and patience.

Regards

ingo