We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Course Of The Month
2 days, 11 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
How do I assign an action button on a form to open a pop-up subform?
Posted on 2006-10-24
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!
@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!
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
4
3-
2
9 Comments
Active today
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.
@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.
Active 2 days ago
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?
Paste in your exact commandline, are you entering the subformname as "subformname" or taking the value of a variable set elsewhere for instance?
Active 2 days ago
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
"My popup window for " + ContactName
Active 2 days ago
Oops, now I can't read. Sjef did say it should be text. I blame getting up at 5am!
Active today
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))
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))
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!
Thanks a million to both of you... and thanks for responding to my question so quickly!
Active today
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.
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.
Featured Post
June's Course of the Month is now available! Every 10 seconds, a consumer gets hit with ransomware. Refresh your knowledge of ransomware best practices by enrolling in this month's complimentary course for Premium Members, Team Accounts, and Qualified Experts.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
For Desktop Techs:
How to retain a user's Notes configuration data when swapping out the end user's computer.
(Assuming that you are not upgrading to a completely different version of Notes client)
All you need to do is:
1) install Notes o…
I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers.
Hopes this gives you ideas on visualizing your data in new ways ~
Create a calculated field in a query:
…
Suggested Courses
Course of the Month2 days, 11 hours left to enroll
696 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.