data selection

[Vikki]

Access 2003 Win XP Novice User

I am using a form to input data and in one of the fields I want to type a
letter and have all previous entries with that letter display so that one can
be chosen. Is there a way to do this? I'm trying not to creat a separate
table with this information, it would be a lot of extra work as there are
well over a thousand different choices.

I can so some programming if VERY clear instructions are given on where to
insert the code.

Thanks!

 

[Allen Browne]

The simplest way to do this without any programming is to use a combo box.

Say your table is named Table1, and this field is named Comments, then you
just set the combo's Row Source property to this:
SELECT DISTINCT Comments FROM Table1
WHERE (Comments Is Not Null) ORDER BY Comments;

Make sure the combo's Limit To List property is No, and type away.

More information:
http://allenbrowne.com/ser-27.html#FreeFormText