Preventing duplicates

[Jenny1]

Hi, How do you normally prevent duplicates being inputted into you forms.

My Idea is this

The input text box doubles up as a dropdownlist of current values held in the database for that field.

So when you access the organisation form and go to the first text box as you enter the 'I' for IBM All the orgs with 'I' appear. When you see that the organisation your inputting already exists you will stop and move on to the next form.

I dont know how to do this, so currently I have set the field OrgName as Indexed: Yes (No duplicates) but this isnt really any good as the user enters all the other details and clicks submit before the error message comes up.

I have attached my file for you to understand this better.

 

[ColinEssex]

Jenny,

Have a look at this quicksearch database I've attached in this thread. It'll refine the search every time a new letter is typed in. You can adapt it to suit your needs

(credit to Parker several years ago for this)

Col

 

[Jenny1]

Hi Colin,

Thanks that looks really useful.

I have copied and adjusted the form.

But when I try and open it I get a messgae saying.

"The record source 'tblCompanies specified in this form does not exist"

Except that I have removed all traces of table companies from the form??

What am I missing.

Also Im having trouble with the query how should I go about setting this up.

Any advice would be appreciated.

I have attached the database. The form is called Search Organisations


I would appreciate your help with all the above.

Thanks in advance