Validation Rule and Validation Text

[Cathy]

I have set up a table with a field named "Participation"
and I have that field's Validation Rule property set up
as "Yes" or "No", thereby limiting the value(s) that can
be entered into the field. Users are allowed access only
to the form for this particular table. Is there a way to
limit the values for the "Participation" field in the
form? Thanks.

 

[Rick Brandt]

I have set up a table with a field named "Participation"
and I have that field's Validation Rule property set up
as "Yes" or "No", thereby limiting the value(s) that can
be entered into the field. Users are allowed access only
to the form for this particular table. Is there a way to
limit the values for the "Participation" field in the
form? Thanks.

The form should pick up the validation rule that you defined in the table.
That's pretty much the whole point of putting the rule in the table, so you
don't have to define it over and over if you use multiple forms.

 

[Larry Daugherty]

The easiest way would be to change that textbox to a checkbox or an option
button (so long as there are no other option buttons on the form)

HTH

 

[Cathy]

Thanks, Larry, for your input - but the validation rule
was working correctly, after all, both in the table and
the form. I will, however, keep your suggestion in mind
for a future time.

 

[Larry Daugherty]

Cathy,

Using one of the methods I suggested you'd end up with a field limited to
one of two values.

HTH