You are right here, cint was important part
make the difference between result is 0 or 1Code:If DCount("*", place, "[select] = Cint(" & inputData & ") And IsNull([ver1_2])=True") > 0 Then
You are right here, cint was important part
make the difference between result is 0 or 1Code:If DCount("*", place, "[select] = Cint(" & inputData & ") And IsNull([ver1_2])=True") > 0 Then
No!, If you type the correct syntax it will work. You are changing the code without any clue as to what each piece is meant to do?
Look at the links that Gicu has posted and see if you can see where you are going wrong.
One technique I use is to put the criteria into a string variable, debug.print that until I get it correct, then just use that in the function?
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba