pick list

K

Kirsten

I have a form with several fields that have pick list. I
only want the user to be able to choose names off of the
list.

Currently they can choose a name off of a list but they
can also enter in any name they want even if it is not on
the list.

How do I change this in Access 2002?

Thanks
 
S

SteveS

Kirsten said:
I have a form with several fields that have pick list. I
only want the user to be able to choose names off of the
list.

Currently they can choose a name off of a list but they
can also enter in any name they want even if it is not on
the list.

How do I change this in Access 2002?

Thanks


Open the properties for the combo box. Click on the data tab. Change
'Limit to List' to YES.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top