Required text field from combo box

[Isidore]

I have a table that includes a field, INTAKE, which stores the name of a
person answering phone calls. It's a text field, and it gets filled in by a
combo box associated with a one-field lookup table.

It was set up this way because there's an enormous turnover of the people
who do this work for us (though there are usually only about half a dozen or
so at any given time). We use the combo box to avoid typos, and we use the
lookup table so the supervisor can change names personnel whenever he needs
to without asking for help.

I would like to set this field up so that's it's impossible for someone to
type anything in, but still keep it a text field. In other words, I need it
to be a REQUIRED field that can only be populated by selecting an item from
the associated combo box. Is this possible?

Thanks in advance,
Isidore

 

[Jeff Boyce]

Isidore

If you are working in a form, you can use the Limit To List property to only
allow entry of valid (i.e., from the lookup table) values.

If you are working in a table, and, perhaps, have the data field defined as
a "lookup" type, I don't believe you have a way to limit (that's only
available via forms). Moreover, if you are working directly in a table,
build a form!

Good luck!

Jeff Boyce
<Access MVP>

 

[Isidore]

Exactly what I needed. Thanks!