Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Combo box validation 1

Status
Not open for further replies.
AFKAFB

AFKAFB

Programmer
Joined
Aug 22, 2005
Messages
26
Location
US
All

I've a number of combo boxes with YES/NO options on a form.

However, its possible to type in different values which i want to prevent.

Is this prevented through the data validation to limit the user to yes/no.

regards

chris



 
Sort by date Sort by votes
How are ya AFKAFB . . . . .

In the [blue]NotInList[/blue] event of each combo:
Code: 
[blue]   MsgBox "You Must Make a Selection From The DropDown List!"
   Response = acDataErrContinue[/blue]

Calvin.gif
See Ya! . . . . . .
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

monkeysee
  • Locked
  • Question Question
Combo Box - Limit results
Replies
1
Views
695
dhookom
dhookom
visitnag
  • Locked
  • Question Question
combo box entries problem
Replies
8
Views
771
visitnag
visitnag
JanaLNelson
  • Locked
  • Question Question
Filter as you type combo box in Access
2 3
Replies
54
Views
4K
JanaLNelson
JanaLNelson
dhookom
  • Locked
  • Question Question
Make second combo box display records dependant on selection from first combo box
Replies
2
Views
504
dhookom
dhookom
JayRo71
  • Locked
  • Question Question
Select records on subform using a combo box with a twist
2 3
Replies
56
Views
3K
JayRo71
JayRo71

Part and Inventory Search

Sponsor

Back
Top