allow user changing of default value

[salmanjavaheri]

Hi, i have a field in a form which needs to have a default value,
however, i would like the end user to be able to change this value
easily, how can this be done? is it a simple case of setting the field
to find its default value from a table which the user can input their
desired default values? Or is some vba required?

thanku

 

[Mr. B]

Hi, i have a field in a form which needs to have a default value,
however, i would like the end user to be able to change this value
easily, how can this be done? is it a simple case of setting the field
to find its default value from a table which the user can input their
desired default values? Or is some vba required?

thanku

For each control in your form that you want to have a default value,
just place that value in the "Default Value" property of that
control. Your users will still be able to change that value. It is
only at default value not a required value.

HTH

Mr. B

 

[Carl Rapson]

Hi, i have a field in a form which needs to have a default value,
however, i would like the end user to be able to change this value
easily, how can this be done? is it a simple case of setting the field
to find its default value from a table which the user can input their
desired default values? Or is some vba required?

thanku

A table of default values is a good way to go, but you will need a little
VBA code to load the default values (probably in the form's Load or Current
event). You can also then create a simple form to allow users to modify the
default values.

Carl Rapson