Save form at runtime

[DaveE]

Hi Programmers
I want my database users (in different divisions of the company) to be able to change the default text of an unbound label that resides on the database menu.
That is, Click a control and input some text that will permanently change the text on the opening form.
It is pretty straight forward, but I am not able to save the new form structure.


Is it possible, or do I need to store the text in a table?
Any assistance is greatly appreciated
Thanks, Dave

[ajetrumpet]

what for? what is the purpose?

[DaveE]

Hi Adam
The database will be populated differently by each department.
I was hoping that a title would avoid confusion for people with access rights to more than one area.

[ajetrumpet]

Hi Adam
The database will be populated differently by each department.
I was hoping that a title would avoid confusion for people with access rights to more than one area.

you said 'change the text on the opening form'. what text? a label? the form title/caption? the database title? you can do all of this, but depending on which one you want to do, the complexity changes.

[DaveE]

Hi Adam
I was thinking an unbound label or text box on the opening form that can be changed easily by individuals to hold their department name.

[ajetrumpet]

Hi Adam
I was thinking an unbound label or text box on the opening form that can be changed easily by individuals to hold their department name.

either that, or what you can do, what we do sometimes, is ask for an input upon startup, store that in a table called 'owner' and set the form labels or headers to lookup those values when they are opened. for a textbox, say you can enter the following as the cs:

=dlookup("field", "ownertable")

[DaveE]

Thanks, I appreciate the advice.
All I was asking was (see original post) is it possible to save the structure without creating another table.

[michaeljohnh]

Thanks, I appreciate the advice.
All I was asking was (see original post) is it possible to save the structure without creating another table.

Can VB code be used to change the default value of the label/textbox? That sounds like what youre describing. If it can than that might do the trick.

[DaveE]

Yes, that is all I was attempting to do.
Permanently change the default setting of a label/text box using code.
It is easy to change, but I was not able to save the form to retain the change.