Use a combo box. Here's a link to the on-line help topic ...
http://office.microsoft.com/assistance/hfws.aspx?AssetID=HP052405811033

Signature
Brendan Reynolds
Access MVP
Yes, I know that will give the user multiple options to pick from. However
they are constantly putting in new data and I need it to be able to do what I
mentioned. I have seen this feature elsewhere but can't remember how it was
done.
> Use a combo box. Here's a link to the on-line help topic ...
>
[quoted text clipped - 9 lines]
> >
> > I don't know how difficult this will be, but thanks for the help!
Brendan Reynolds - 28 Feb 2007 07:57 GMT
There's an example of how to add items to the combo box's list at the
following URL ...
http://www.mvps.org/access/forms/frm0015.htm

Signature
Brendan Reynolds
Access MVP
> Yes, I know that will give the user multiple options to pick from. However
> they are constantly putting in new data and I need it to be able to do
[quoted text clipped - 19 lines]
>> >
>> > I don't know how difficult this will be, but thanks for the help!