Do not allow any manual data entry

[Big Tony]

I have a two field table, where the first fields allows a
user to choose from a drop down box a list of categories
(from a table).

Based on their choice of category, the computer runs a
macro (shown below) which gives them a choice of
subcategories to choose based on their first choice. In
both fields I have chosen limit to list, but somehow the
second field is still allowing data entrants to type into
the field. How do I stop this madness?


(SELECT [Diagnoses Categories].DXCategoryID, [Diagnoses
Categories].DiagnosesCategory FROM [Diagnoses
Categories]; )

 

[Jeff Boyce]

From your description, it sounds like you have:

* used the lookup data-type field in a table, and
* allow data entry directly in the table.

These are both confusing practices. Check
www.mvps.org/access/lookupfields.htm for info on the former.

Data entry is better handled in forms, which have a rich Event environment,
better for controlling what users see and can do.