Default values

[JakeN]

I tried setting the defualt value of a control threw a macro but it doesn't work. Well it works...but as soon as I exit the form the defualt value that I set erases.
SetValue= Item=[Forms]![Main Form]![Danger?].[DefaultValue]
Expresion=[Forms]![Main Form]![Danger?]

 

[Fornatian]

Why don't you just set it in the default property of the control on the form?

 

[JakeN]

Well, this particular value can change. Depending on the users preferece. So the defualt value can't be hard coded so to speak and I would like to make the changing of the defualt value user friendly.

 

[Fornatian]

What I meant was why don't you set the default value dynamically. In the default value enter:

"=[Forms]![Main Form]![Danger?]"

without quotes, this will dynamically change as you change records in the main form.

Is this what you are looking for?
If not please expand using a real life example.

 

[JakeN]

yes I think that is what I'm looking for. Thats a good idea, but I tried it and it doesn't keep the value. I close the database then reopen it and it puts "#Error" in the control.

Just to clarify: I'm working with only a single control. If the user pushes a button, whatever value is in that text box I want to be set to the default value of that text box. Thanks for your help.


[This message has been edited by JakeN (edited 12-28-2000).]

 

[JakeN]

I came up with a solution. Its much more complicated then setting the controls default, but it works. I simply linked the control to a table with one field in it. So whatever value is entered is stored in the table permently. It works