Create a Default Value with the Expression Builder

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a form with 5 text boxes (critical, high, medium, low, &
informational) in which I want to enter data via the form. How can I use the
expression builder to create an expression that will make the default value
in each text box equal to "NO."

I also have a table that is connected to this form therefore whatever is
typed in the form, I also want to show up in the table itself.

Thanks
 
Just curious, why don't you just use a combo-box to select the "priority"
and store the value in ONE field? Why do you want five boxes to express one
thing?
 
Rick,
I hadn't thought about that. I can say that the form updates a table. In
the table I have the columns critical, high, medium, low, & informational.

If I modify my form based upon your suggestion, how do I create the
combo-box to select the "priority?" Secondally, how will the combo-box update
the table?
 
You would change your table and make one field called priority. When you do
so in table design-view, you could use the LookupWizard in the DataType
field and it will let you build the list. Then, in your form, simply drop
tha tnew field onto your form from the field list and all the settings
should be there.
 
My preference would be to build a combo box bound to the new field that would
have as it's list the valid values. I try to avoid using your option,
because it has an adverse effect on upsizing.
 
Back
Top