Form Field - No Duplicate

[John Torres]

Is there any way that a field in access form tells you immediately once a
record is duplicated? I went to Table and indexed it to "No Duplicates" but
it appears that a dialogue box appears after the whole entry form is filled
and then the warning sign.
Thanks,
John

 

[Al Campagna]

John,
Do a Refresh on the AfterUpdate of the field involved.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[John Torres]

Hi Al,
How do i do that? Is that a code that needs to be written? I tried typing
refresh and it was looking for macros.
Thanks again.
John