How to stop duplication

[muppet123]

Hi,

I have implemented a small DB which has 4 users. My problem is that 2 users have duplicated a record. The PK is an autonumber. Is there a way of having some sort of autocomplete in a field (in this case the customer name) that would give a way of detailing previous entries of same text?

Table: tbl_CusDetails
Field: CompanyName

Any help would be greatly appreciated.

Mup'

 

[PHV]

You may consider a ComboBox with AutoExpand=True

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[muppet123]

Thanks PHV for your reply, would this slow the form load up? There will be probably 3-4 thousand entries over the next few months.