Issue Cmds to Different DB

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm still trying to figure out how check to see if another db has a form open
and if not then have THAT db open a form within itself. I've tried the
reference routine but when I executed the function in the other db to open
the form it opened the form in the current db and then tried to find the
tables in the current db.


Any other ideas?
 
Hi John, i tried it again and it worked

1. Create MDB1 with function that open a form, Form1
2. Create MDB2, with reference to MDB1 and run the function I created in
stage 1, and it opened the form
3.I also created a form in MDB2 with the same name, and it still opened the
form from MDB1.

There are some functions that is you run on MDB1, it will search for the
tables in MDB2 such as DLookUp, DSum etc
But for your case, I tried it and it works, just make sure that you don't
have a function in MDB2 with the same name of the function in MDB1, that can
cause your error, becuse Access will give the priority of functions to MDB2
 
Back
Top