Adding to forms

  • Thread starter Thread starter Ed Powell
  • Start date Start date
E

Ed Powell

I have several forms in my database that have unnamed
records reserved for the administrator to add categories
to the database. For instance, table1 is linked to table2,
3, etc. In table2, I have rows listed as cat-1, cat-2, cat-
3, etc. On my form I have a second tab with the cat-?'s as
text boxes. The second tab and text boxes are not visible
until the administrator click on an "add" command. When
that happens, the second tab and its textboxes display. My
question is how can I let the administrator change the
title to the textbox to whatever wanted? This would allow
them some limited ability to customize the database to
their needs.
 
You are violating normalisation. What happens after you have run out of
category fields ?

What you do is have a table of categories, related to the other table. Then
you are free to add as many categories as you like to the table, with no
changes to field names, running out of fields etc. A combo box to select
the categories applicable to the record in question handles this really
well.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Have a table that the administrator can modify with fields to contain the text
of the labels. Then you can use code to lookup the values and assign them to
the caption property of the labels when you open the form.

Without more fully understanding your structure that is as far as I can go.


tblCustomFields
fldName - the field name or control name that you wish to label
DisplayText - the Label Text to be displayed.

Of course, you can add other fields to the table to make this more detailed.
For example, frmName for a specific form, so that the display text could be
varied by form (not usually a good human interface factor, unless you need to
display "Social Security Number" in one context and "SSN" in another).
 
Back
Top