using 2 apps

[Bob McClellan]

How can you jump to one db app from another...?

I know I can do this to open another app...

Dim accapp As Access.Application
Set accapp = New Access.Application


accapp.OpenCurrentDatabase ("c:\trc\trc.2k.adp")
accapp.Visible = True

But this opens a new instance each time.
I want to double click a control in one app and jump to the other app

Any help is much appreciated.
tia,
..bob

[goodguy]

Omit the New keyword when you call it subsequently.

[Bob McClellan]

thanks for you reply goodguy.
..that does not work. I tried it before writing my post.

I did get FollowHyperLink to work. It works great.... however, after jumping to the
other app, I'd like to filter the form to a specific account number.

Here is the scenario.... 2 of the many apps in place here are Dispatch and Collections.
The people working in Credit always have both open and are constantly toggling back and forth.
When They see new orders needing credit approval they bounce to the collections program to see the aging, notes, credit info and other related data.
I'd like for them to simply double click the account# in the dispatch program and go to the collections program and filter on that account.

Does anyone know the syntax to use to control forms in one app from another app.
I can't use Forms![frmMain]!frmCustomersToView.form.filter = "Addr = ' & me.addr & "'"
because it's looking for frmMain which does not exist in the current app.

Hopefully the explanation is clear enough to convey what I am looking to do.
thanks in advance,
..bob

[goodguy]

Why don't you set the accapp variable as a global and then keep reusing it without having to initialize it every time?

[Bob McClellan]

I've never worked with that. If you wouldn't mind, could you supply some example code?
I'd sure appreciate it.

I am very familiar with doing whatever I want within an app with regard to referencing form controls and subforms...
I just have never referenced something in another app.
I have been scouring the net via google but can't seem to find anything with examples of this.

I simply want to
-double click and leave the dispatch app.
-make the collection app the active app ( I can do this )

What I need help with is....
Reference the collection app from the dispatch app so I can ...
-set the filter property on the subform [CollectionsApp].Forms!frmMain!CustomersToView].form.Filter

thanks in advance,
..bob

[goodguy]

Why don't you show us the code you have so far and I will see how it can be tweaked to stay open?