DJRave


Hey there,

I've written 3 subs to log data during import. I want to start all 3 subs by using another script but I can't get it to work. I've tried using the Run method but everytime I try to run the script it comes up with a Run-time error (7952): You made an illegal function call.

Does anybody have a solution to my problem

Thanks

Private Sub Runmultiplesubs()

Dim app As Access.Application
Dim DB As Database

Set app = CreateObject("Access.Application")
Set DB = CurrentDb
app.CurrentDb

app.Run "LogELEC"
app.Run "LogGAS"


End Sub




Re: running a sub from another sub

ADG


Hi

I asked the sme question in this forum and got a reply that worked see below link.

http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1618380&SiteID=1

Regards

ADG