The fields constructed by reference to form controls with the Is Null criteria.
VIP
Windows 7 64bit 
Access 2010 32bit
The fields constructed by reference to form controls with the Is Null criteria.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Novice
Windows 10 Access 2013
They are auto generated by access. If you have a search with a,b and c fields and you want it to work if any of them are null. a=.. ., b=..., c=... OR a=... b=... c=null OR a=... b=null c=... etc etc. until you get to a=null b= null and c= null
EDIT: It's all good nowI fixed it
Last edited by urosm993; 12-24-2015 at 11:12 AM.
Problem with UpdateBatch statement - empty date fields no longer empty
Update Query on empty fields
Posting Permissions
Reply With Quote