Can i have a drop down menu in access table itself

[Kingkumar]

Hi,
I know i can use a form to have user enter only one of the choices i give into the field as a value.But i was wondering if its possible to have the database table with field with dropdown menu or something so that when user enters the value for the field he enters only one of the choices/options which already defined.I am trying to develop a database where every user can add entry to the database so thought why not to make user directly enter the data rahter than using a form
thanks

 

[JeremyNYC]

In A2K and A2K2 you can. But you never should. Users should _never_ be allowed to enter data directly into tables. Users, in fact, should never be allowed to see tables.

It takes some time to develop an Access application, but if you do it carefully, you gain huge benefits. Take the time to build the forms you need so the users don't mess things up too badly. You'll be glad you did.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Professional Development for Clients Large and Small

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.