default value update

[Rizza]

I have created a form to store variables in the default value properties of
text boxes. I have written the code to update the default value of a textbox
from a button.
Steps
1 capture new value
2 open form in design
3 set default value
4 open form normal
5 save
6 refresh text box

Form will be pass protected. Then I wish to make an mde to prevent any
changes without password.

My "first" problem, I cannot open a form in design in an mde. Next I cannot
seem to save the changes to the default values without opening the form in
design.

If anyone has any suggestions, even to how I am storing the variables please
let me know. The variables should be modifiable from the form.

 

[Guest]

It is not necessary to be in design view to change a default value. You can
do it while the form is open in any view.

If you need to retain the updated default value after the form is closed,
then you will have to close it using this syntax:

DoCmd.Close acForm, Me.Name, acSaveYes

 

[Guest]

Rizza,
You definitely don't need to open a form in design view to pass values to a
textbox or change property values.

I am guessing from your post that you are attempting to pass data by storing
that in the "default" property of a textbox control.

The form has a "tag" property that may be useful in this setting if it's a
single value you're wanting to save.

Can you describe what you're trying to accomplish (what is your end goal?)
so that a more efficient strategy can be devised.

 

[Rizza]

Niether solution has worked so far.

End goal: I am running a process which runs many queries, sub routines and
functions. I have many process variables used in the queries and such. I
have decided to store the values in the default value property of the text
boxes on a form. It seems I should be able to call code to change these
values which it does. However, if i close the form it does not retain the
updated default values.
Running Access 2003

 

[Rizza]

Does anyone else have this problem or is it exclusive to my machine. It
seems to me access is allowing the form to save but does not actually commit
the changes. Can anyone offer a suggestion. I am also open to design
changes.