Notification in Form if there is a Duplicate Entry

[Guest]

In Excel, when you're typing into a list, the cell will begin to do an
autofill based on what you're typing. For example, If I have a list of order,
and under customer name I begin to type "Herman Miller". If Herman Miller is
in the list anywhere above where I'm typing, then it will autofill in.

Is there anyway to use a feature similar to that in Access.
I want to enter Projects into a log, but I want some sort of notification if
something similar exists. So if I am entering a Job Name and begin typing
"Grand Haven High School Auditorium", and I already have that job listed, or
maybe I have "Grand Haven HS Auditorium" Listed, then I want to be alerted to
the fact that the job may already be in there.

How can I do this using a form entry in Access.

Thanks in Advance

 

[Stephen at ZennHAUS]

In Excel, when you're typing into a list, the cell will begin to do an
autofill based on what you're typing. For example, If I have a list of
order,
and under customer name I begin to type "Herman Miller". If Herman Miller
is
in the list anywhere above where I'm typing, then it will autofill in.

Is there anyway to use a feature similar to that in Access.
I want to enter Projects into a log, but I want some sort of notification
if
something similar exists. So if I am entering a Job Name and begin typing
"Grand Haven High School Auditorium", and I already have that job listed,
or
maybe I have "Grand Haven HS Auditorium" Listed, then I want to be alerted
to
the fact that the job may already be in there.

How can I do this using a form entry in Access.

Thanks in Advance

Use a combo box fed by your list of job names (where ever you have them
stored) so that when you start typing a job name that exists, the list will
automatically start filtering based on what you type.