"KayC" <ka******@yahoo.co.ukwrote in message
news:8d**********************************@1g2000hs l.googlegroups.com...
Hi
I am using Access2002
I have a form with 5 text boxes which are parameters to a function
3 parameters are optional in the function
How do I pass the empty textbox values to a optional parameter?
Completely stumped on how to do this
Any ideas?
Regards
KC
Checkout the "Optional" parameter in vba Function command.
or
Use the Nz() function when you make the function call:
=TestFunction(Nz(Param1,""), Nz(Param2,""), Nz(Param3,""), Nz(Param4,""),
Nz(Param5,""))
Fred Zuckerman