Z
zSplash
My Mainswitchboard has a combobox that opens a parameter query. If the user
hits cancel (instead of entering a name when asked), an error is generated,
and the user has to "halt" the macro execution. The query parameter I've
tried is:
WHERE ((([theNames].MailingAddress) Like "*"+[Household:]+"*" Or
([theNames].MailingAddress) Is Null) AND (([theNames].City) Like [City:]+"*"
Or ([theNames].City) Is Null))
How can I make one of the parameter criteria be that if nothing is entered
(i.e., the user hits cancel instead of entering something, or the user
enters an empty string), the query is closed, and the main switchboard is
again "there"?
TIA
hits cancel (instead of entering a name when asked), an error is generated,
and the user has to "halt" the macro execution. The query parameter I've
tried is:
WHERE ((([theNames].MailingAddress) Like "*"+[Household:]+"*" Or
([theNames].MailingAddress) Is Null) AND (([theNames].City) Like [City:]+"*"
Or ([theNames].City) Is Null))
How can I make one of the parameter criteria be that if nothing is entered
(i.e., the user hits cancel instead of entering something, or the user
enters an empty string), the query is closed, and the main switchboard is
again "there"?
TIA