Consulting a Duplicated Register (1 Viewer)

maluna

Registered User.
Local time
Today, 20:18
Joined
Sep 2, 2010
Messages
12
Hi Guys,

I have a table where we assign computers parts so that our technicians can fix them in our warehouse. Every day we receive new calls, sometimes duplicates and sometimes reincident calls ( same equipment )

How can I get one specific value im my form, find out if I have already this entry in my table in order to know if it is a duplicate value or a new problem in the same equipement.

By using excel we copy the value and by using find we can read if the new problem was previosly logged.
 

vbaInet

AWF VIP
Local time
Today, 11:18
Joined
Jan 22, 2010
Messages
26,374
Look into these two functions:

DCount() and DLookup()
 

Users who are viewing this thread

Top Bottom