How do I assign an action button on a form to open a pop-up subform?

I've tried using the following formula that I found here in another thread:

@DialogBox( subformname ; [AutoHorzFit] : [AutoVertFit] : [NoCancel] :
[NoNewFields] : [NoFieldUpdate] : [ReadOnly] ; title )

The subform is not opening when this is used.  I'm sure part of the problem is that I'm not sure what needs to be entered into the "title" part of the formula.

The form should remain open while the subform is up.

Thanks in advance!
justkrissyAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
Advertise Here
 
Sjef BosmanConnect With a Mentor Groupware ConsultantCommented:
The full syntax (copied from the Help db):
    @DialogBox( form ; [AUTOHORZFIT] : [AUTOVERTFIT] : [NOCANCEL] : [NONEWFIELDS] : [NOFIELDUPDATE] : [READONLY] : [SIZETOTABLE] : [NOOKCANCEL] : [OKCANCELATBOTTOM] ; title )

It could be my eyes, but I think you just invented a new keyword: NoCancel... I suppose you meant NoOkCancel ;-)

Title should just be text. I assume you want to use a dialog box to modify specified fields on the current document? That's what the Formula version is for. The LotusScript variant of DialogBox is a lot more flexible, in the sense that you can call up any document on the screen in a dialog box.
0
 
Steve KnightConnect With a Mentor IT ConsultancyCommented:
It's there for me in your pasting ;-)  Nocancel does what it says on the tin... you just get the OK button.

Paste in your exact commandline, are you entering the subformname as "subformname" or taking the value of a variable set elsewhere for instance?
0
 
Steve KnightIT ConsultancyCommented:
Neither of us actually answered your title question.  The title is just the title that will appear above the window, it could simply be "My popup window" (complete with quotes), a variable or field or a combination, e.g.

"My popup window for " + ContactName
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Access It Instantly
 
Steve KnightIT ConsultancyCommented:
Oops, now I can't read. Sjef did say it should be text.  I blame getting up at 5am!
0
 
Sjef BosmanGroupware ConsultantCommented:
And I blame solving problems after midnight :$ The NoCancel is there, in the list... Shame on me...

The formula seems correct therefore, so I assume it's some earlier code in the same button, or the form that isn't correct. Can you add some @Prompt statements, so you can see the progress? Suggested syntax:
    @Prompt([Ok]; "Variable xyz is "; @Text(xyz))
0
 
justkrissyAuthor Commented:
I had to split the points even on this one.  sjef gave excellent advice, but I never would have got the formula to work if dragon-it hadn't noted that I need to put the subform name in quotes!  That is why I couldn't get it to work.

Thanks a million to both of you... and thanks for responding to my question so quickly!
0
 
Steve KnightIT ConsultancyCommented:
No problem
0
 
Sjef BosmanGroupware ConsultantCommented:
Hey thanks! :)

By the way, you wrote in http:Q_22037789.html#17807491 "Can data-entry text fields be used on subforms or are they only for computed fields?":
> I figured it out....

As long as nobody else put a post in that question, you can delete it. Otherwise, you'd have to ask Community Support to remove it.
0
 
justkrissyAuthor Commented:
Noted for future reference.

Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.