Jun 16, 2006 #1 DougP MIS Dec 13, 1999 5,985 US its in a form, not a module. is that why? I get an error Compile Error: sub or function not defined DougP, MCP, A+
its in a form, not a module. is that why? I get an error Compile Error: sub or function not defined DougP, MCP, A+
Jun 16, 2006 1 #2 strongm MIS May 24, 2001 20,240 GB >is that why? Yes Preceed the sub with the form's name, e.g. Form1.MySub (and make sure the form's designer window is closed.) Upvote 0 Downvote
>is that why? Yes Preceed the sub with the form's name, e.g. Form1.MySub (and make sure the form's designer window is closed.)
Jun 16, 2006 Thread starter #3 DougP MIS Dec 13, 1999 5,985 US Dooh Thanks have a star that has saved me a lot of time DougP, MCP, A+ Upvote 0 Downvote