allow user changing of default value

  • Thread starter Thread starter salmanjavaheri
  • Start date Start date
S

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
 
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
Click to expand...

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
 
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
Click to expand...

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
 
Back
Top