Default Value For Final User

[mtagliaferri]

Hi I have tried to look, but have not find the solution

I have a form wich I need in certain fields to have a default value, and this needs to be changed from the final user, I was thinking about taking the data from the previous input, the final user will use the control panel were there is a "push button" to open the form in add mode.
Can I get some help

 

[aleb]

As I could understand you need some fields to have default values when adding the new records. So what is the problem? Define in the properties of those fields the default values.

 

[mtagliaferri]

Hi Alexei, The point is that a final user will not have access to properties of that field, this default value may change quite often, I was thinking to keep track of the last input... example today the user fills a field with the number 1000 for a few days every time the form is opened in ADD mode that field will show 1000 as default, in a week time the final user may decide to change that value to 1200 threfore once changed to 1200 every time the form is opened again in ADD mode the default value will be 1200.

 

[ShaneMan]

Hi Alexei, The point is that a final user will not have access to properties of that field, this default value may change quite often, I was thinking to keep track of the last input... example today the user fills a field with the number 1000 for a few days every time the form is opened in ADD mode that field will show 1000 as default, in a week time the final user may decide to change that value to 1200 threfore once changed to 1200 every time the form is opened again in ADD mode the default value will be 1200.

One thought would be to set the DefaultValue, of the field that will be changing, to equal the last entry made in that field. You could do a DLookup to find the last entry made.

Some one may come up with a better idea but this was the first thought that hit me.

HTH,
Shane

 

[mtagliaferri]

Hi Shane, thanx, but could you give me further help as I am a beginner in access!!!

Thanx

Marco