Create validation rule.

  • Thread starter Thread starter aayrapetov
  • Start date Start date
A

aayrapetov

I am a rookie in this. just started to learn

situation:
I have a form in which I have a combo box with drop down list. I want
this box to accept values only from that drop down, no manual type-in
input allowed. for instance: if the drop down list contains of list of
years from 1990 to 2010, I don't want this box accept anything outside
this range. another one: drop down is a list of names of buildings,
I want to allow values only pertaining to this list, no manual type in
input allow.

Please, would you tell me how to do this.
 
open the form in Design view. click on the combobox control to select it. in
the Properties box, click on the Data tab, and change the LimitToList
property from No to Yes.

hth
 
THANK you MUCH!!


open the form in Design view. click on the combobox control to select it.in
the Properties box, click on the Data tab, and change the LimitToList
property from No to Yes.

hth
Click to expand...
 
you're welcome :)


THANK you MUCH!!


open the form in Design view. click on the combobox control to select it. in
the Properties box, click on the Data tab, and change the LimitToList
property from No to Yes.

hth
Click to expand...
 
Back
Top