Page 1 of 1

[Solved] Basic syntax error

PostPosted: Wed Apr 15, 2015 7:40 pm
by Jjs2060
I have been working on a form for data review and input that uses a big macro. Recently, somehow I lost all macros. I went to my backups and found a database with the macros. However the main macro was out of date but I had a text copy of the latest version (attached). I copied the text and pasted it into the Sub. This macro worked before the problem and now gives this exception: Basic syntax error. "Function not allowed within a procedure." I can't get rid of the error. I feel it has something to do with how I pasted the text file. Any suggestions?

Re: Basic syntax error

PostPosted: Wed Apr 15, 2015 7:46 pm
by FJCC
I'm guessing you have a Sub declaration that is not paired with an End Sub.