Software and Programs Thread, Access Form DCount in Software & Hardware , Games; I have a textbox on one of my Access forms with the following formula in the Control Source. Code: --------- ...

Short Link: http://forum.egypt.com/enforum/showthread.php?t=29695

newbe · 16-02-2009, 04:40 PM

I have a textbox on one of my Access forms with the following formula in the Control Source. Code: --------- =IIf(DCount("*","[qryTest]","[ID]" & Nz([Field],0) & " And [Field2] = '" & Replace(Nz([Field2]),"'","''") & "'") >0,"Possible...

I have a textbox on one of my Access forms with the following formula in the Control Source.

Code:
=IIf(DCount("*","[qryTest]","[ID]" & Nz([Field],0)
& " And [Field2] = '" & Replace(Nz([Field2]),"'","''") & "'")
>0,"Possible Duplicate","")
I would like to add one more "AND" criteria to the formula, but I have not been able to do so. The other citeria is based an a field that is on the form.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Software and Programs Thread, Access Form DCount in Software & Hardware , Games; I have a textbox on one of my Access forms with the following formula in the Control Source. Code: --------- ... Short Link: http://forum.egypt.com/enforum/showthread.php?t=29695