Recent content by DrCaptKirk

I have a question on: How to see if value exisits in Access table then stop the search. My routine above works well, but it looks through the entire table and counts the "hits." What I'd really like to do is search through the table and if it finds one, stop the search immediately and report...

Here is the method I use and it works perfectly. 'Count records usind DCOUNT method Dim CountOfINIDot1 As Integer CountOfINIDot1 = 0 'This is the Workhorse line: CountOfINIDot1 = DCount("[INIDot1]", "tblPropagationrequests", "[INIDot1] = '" & Me!INIDot1 & "'" & "AND...