I'd like to try the COM Server. I created a prg with the class described below in it. I created a new project and added that file. I compiled as an EXE/COM Object. (so far so good). I created a simple form in Access and created a command button and in the click method I added the code:




Set oSrv = CreateObject("myProjectname.myServer")
bFlag = oSrv.SaveData(var1, var2, var3)
Set oSrv = Nothing

where var1, etc are field names from the form's table. When I press the command button during runtime I get and error - "Invalid Outside Procedure".

Since I'm not an Access programmer, I must be missing something. Any ideas?


Sandi