CREATING A GENERIC CODE TABLE EDITOR
Most applications use a number of code tables.
Note
A code table is a list of values used in a set field. The list will usually be static but can be dynamic. An example of a code table would be the tblRatings table.
Coming up with a method for handling them is helpful so that when a new one is added, minimal work needs to be done.
A generic code table editor is probably one of the most simplistic of the techniques shown in this book. All it consists of is one main form and whatever subforms are needed for the various code tables. Figure 28.8 shows the main form, with the tblCategories codes displayed in the subform.
Figure 28.8. The same main form is used with multiple subforms.
The main form used for this ...
Get F. Scott Barker's Microsoft® Access 2000 Power Programming now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
