List box

  • Thread starter Thread starter Rod
  • Start date Start date
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.
 
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
 
Back
Top