X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Dlookup To Prevent Duplicate Entries In two fields in A Subform, Any Version    
post Jul 8 2017, 06:21 AM

Posts: 103
Joined: 8-July 17

Thanks all for posting this example from 2015 it'help me too but how can I use this code to prevent duplicate for two txt fields and one date field combined together ??(AccountNo text filed, DocumentName text field and DocumentDate date field) by the way my Primary key is: DocID.
Go to the top of the page
post Jul 8 2017, 10:21 AM

UA Admin
Posts: 34,106
Joined: 20-June 02
From: Newcastle, WA


First. Welcome to UtterAccess.

Second. It is seldom a good idea to tag a new, different question onto an older discussion. Most people will never even see it. (Being on the admin team, part of my job is to review new posts, but otherwise I would not see it either.)

That said, what you need to do is create a unique index on these three fields in your table.
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    13th December 2018 - 09:55 PM