Control another open instance of access

[vich]

I've tried searching with no luck.
Is there anyway to have one open access application control another open access application. Basically when something occurs in one I would like to trigger and event or change a screen in another open access application. I know I could set a timer to check for something written to a file but i wasn't sure if there was a way to make them communicate directly. Even if having to buy some kind of communication control,dll, etc.

Thanks

 

[SkipVought]

Hi,

Check out the CreateObject and GetObject methods in VBA Help.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[vich]

Thanks I'll try that.

From a quick read it looks like it will do what I want which is when a change is made in one access form it will cause a form in another open access application to change to a new record.