restricting cbobox selections

  • Thread starter Thread starter Junior
  • Start date Start date
J

Junior

Using a cbo with table/query rowsource type
How do i restrict the user from entering something other than from the list
of possible selections?
 
Using a cbo with table/query rowsource type
How do i restrict the user from entering something other than from the list
of possible selections?
Click to expand...

Set the Limit To List property of the combo box to Yes.
Since users may in fact miss-spell, or try to enter a value that is
not in the list, you'll need to place some code in the NotInList event
to handle that.
 
Thanks PC - limit to list is set to yes -
but some of my cbo's still allow other entrys - is there something else i
should look for?
 
Limit to list should stop all entries that are not in the list. For those cbos
where you think they are allowing entries, look to see if there is some code in
the Not In List event.
 
PC and fredg - Sorry - i was mistaken about the cbos accepting other data
not on the list - thanks for your patience
It is working properly
 
Back
Top