June7,
I think I will just use this which you gave me earlier:
Like [Forms]![0001Test]![Status] & "*"
and just make sure there are no nulls in my table. This is easier than all the other possibilities. Do you agree?
Al
Advanced Beginner
Windows XP 
Access 2007
June7,
I think I will just use this which you gave me earlier:
Like [Forms]![0001Test]![Status] & "*"
and just make sure there are no nulls in my table. This is easier than all the other possibilities. Do you agree?
Al
VIP
Windows XP Access 2010 32bit
Yes, require a value in the Status field. You can set a default on the field.
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.
Query Criteria
Posting Permissions
Reply With Quote