can anyone tell me how to use user defined functions in vba. front end is in access 2000 and backend is SQL server. Please help.:(

Go to the modules tab in db window, add a new module and type in your function.
--

Joe

I am sry. I should have explained in a better way.

I have user defined functions on SQL server 2000. I need to call it from my VBA by supplying some parameters. Can anyone tell me how I can do it.

Also when I write user defined functions on SQL server 2000, do I have to store it at a specific place( for ex in the data sub folder of SQL Server).

Any help is greatly appreciated