Problem solve Get help with specific problems with your technologies, process and projects.

How can I switch to a tab containing the field that needs to be completed in form that contains seve

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

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.




  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...