"KayC" <ka******@yahoo .co.ukwrote in message
news:8d******** *************** ***********@1g2 000hsl.googlegr oups.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(N z(Param1,""), Nz(Param2,""), Nz(Param3,""), Nz(Param4,""),
Nz(Param5,""))
Fred Zuckerman