Tabs to populate fields

[BillA]

Wondering if it is possible to have a number of tabs that, when starting a
new record from within the tab - have a field contained in a common table
populated with the appropriate text corresponding to the tab.

As an example, say you have 3 tabs; Application, Renewal and Amendment. If
I was to use a common comment table for all 3, and decide to add a comment to
a record within the Renewal tab, a field within the comment table will be
filled with "Renewal" and the same would happen with the other tabs.

I am trying to consolidate and simplify tables and thought I could use a
common comment table to support the Application, Renewal and Amendment that
are tied (1:M) to a Project Table.
Any thoughts, advice, admonitions?

 

[Arvin Meyer [MVP]]

You can do what you want by reading the page number of the tab control when
you pop up your Comments form. It is just as easy though, and a better
design practice, to add a field for CommentType and allow the user to
choose. At the very least, add the field, even if you populate it from the
click event of the button that opens the form.