Combo box and typing

  • Thread starter Thread starter AmandaH
  • Start date Start date
A

AmandaH

I have a combo box with is linked to a column in a table. This column
can only have the values that are already listed in the combo box. How
do I prevent the user from entered any other values then what is
listing in the combo box?

~Amanda~
 
Amanda

Are you saying that you have a field in a table that is set up as a "Lookup"
data type? Or are you saying you have a combo box control on a form?

If the former, stop now! Scan the tablesdbdesign newsgroup for reasons why
using "lookup" data type fields in tables is a bad idea.

If you are using a combo box in a form, you can open the form in design
mode, select the combo box and modify its "LimitToList" property. Note that
you can't do this if you are working in the table directly.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Set the limit to list property to yes

Pieter

AmandaH said:
I have a combo box with is linked to a column in a table. This column
can only have the values that are already listed in the combo box. How
do I prevent the user from entered any other values then what is
listing in the combo box?

~Amanda~
Click to expand...
 
Back
Top