How do I call a routine in a Module from a button click

[Tfrank]

I am trying to use the "How can I do an automated back-up of my attached Back-End Data?" code from the FAQ of this site. I have place the code in a module and it runs fine from in the design view of the module. When I press a button which calls the backup routine, I get the error can't find Macro "Call Backup". It is not a macro I am trying to run but a routine in a module. I am sure I am doing some thing simply wrong. Thanks for the help.

Tfrank

 

[Philly44]

Take out the Call part, that might to do it.
Just put in Backup

 

[DougP]

Put this in the code window of your button


dim x as variant
x = yourfunctionmane()

DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive