List box

R

Rod

Hi all,
value should be picked from list box only in a field of table, shouldn't be
allowed to enter any other value other than list box by keyboard entry.

Could any one help me ASAP?

Thank you.
 
K

Ken Sheridan

Firstly, if you haven't already done so, you should ensure that the
constraint is enforced by creating a relationship between the 'look-up' table
and the table containing the foreign field in question. In the relationship
ensure that referential integrity is enforced.

Then, as Doug says, use a combo box on a form for data entry and set its
LimitToList property to True (Yes). It may simply be that you are confusing
the terms, but a list box is rarely appropriate as a bound control; generally
a combo box is to be preferred.

Ken Sheridan
Stafford, England
 
Top