I have a database with several forms, one of which contains a programmable table containing several tabs with other tables. I am running a Case/Select statement to run a field validation check from the querysave event of each form based on the form name. With the form containing the programmable table, how can I get it to switch to the tab containing the field that needs to be completed? I have a GoToField statement in the code, which does put the cursor in the proper field, but it does not switch over to the tab with a validation error. I have updated the error prompt to include the name of the tab, but I would really like to have it display the tab corresponding to the field.
The only way for you to make the table move to the proper tab as well is to change the table into a programmable table. This method is explained in detail in the Designer Help, but here is a start:
A programmable table is controlled by a field. This field has the same name (case-sensitive) as the table name, preceded by a sign. The table name is set in the HTML properties of the table, using the Name field. Each row (tab) gets a row tag to be set by you. Based on a formula you set, you set the value of the $ field to the name of the row you wish to show. For example, if you have two tabs, one of them is called "a" and the other one is called "b," setting the value of the $ field to "b" will make the table switch to that tab, by using a @RefreshHideFormulas.
Since you know which field needs to be completed, you then also know to which tab to switch and can therefore perform the tab change first before putting the focus on the field.
Dig Deeper on Lotus Notes Domino Administration Tools
Related Q&A from Hans Van Der Burg
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.