Drop down list in Table

[bluedigital]

I have my users entering some information on the back end of the database using the just the Table. Data is pulled from a query and then minor changes have to be made to the record, via the table.
Is there a way to limit what users can type in a field, such as a list box, from the table view? I currently have a list of users that can be selected on the screen form, so I was wondering if I could do the same thing from a table view. Any ideas?

 

[boblarson]

I have my users entering some information on the back end of the database using the just the Table.

EEEEEKKK!! Not good, not good at all!

Data is pulled from a query and then minor changes have to be made to the record, via the table.

Not true, use a form! You should not give users access to the tables and queries directly as you lose control over things that way and they can pretty much do whatever they want.

Is there a way to limit what users can type in a field, such as a list box, from the table view?

It's called a lookup field and you do NOT, I repeat, do NOT want to use them. See here for more about that:

http://www.mvps.org/access/lookupfields.htm


USE FORMS for this and you can have your combo boxes, list boxes, etc. AND you can control what happens.

 

[RuralGuy]

Others will chime in as well but users should *never* see a table directly. All of the interaction with your tables should be through forms or you loose control of the integrity of the data in the tables.

 

[missinglinq]

Chime! Chime! Chime! We really can't say this too many times, bluedigital!

Users + Direct Table Access = Disater!

Linq