alktrigger
Aimless Extraordinaire
- Local time
- Today, 14:23
- Joined
- Jun 9, 2009
- Messages
- 124
I'm trying to create a query that will update as a textbox is filled, but if there is nothing in the textbox I want it to act as if there is no criteria
What do I replace ShowAll with?
Code:
IIf(len([Forms].[frmMembers].[txtLastName]) > 0 , _
InStr(1, Left([Forms].[frmMembers].[txtLastName,_
len([Forms].[frmMembers].[txtLastName])), [COLOR=Red]ShowAll[/COLOR])
What do I replace ShowAll with?