2 database problems

ok here is my problem. I have 2 databases and I have a form that is going to be used for personal inventory file. they will select from one or both databases and put it into a third database how about do i do this? Any Suggestions?

Thanks

You can open multiple databases in your program.

how?

If you've got 3 databases, you can use 3 data controls.

so there is no way except for putting 3 data conntrols in there to access those databases as one

Here is an example of opening two databases using DAO

Code:

---

    'Open the databases
    gsRWTSPath = App.Path + "\data\rwts.mdb"
    gsRWTUPath = App.Path + "\data\rwtu.mdb"
    Set gdbRWTS = Workspaces(0).OpenDatabase(gsRWTSPath)
    Set gdbRWTU = Workspaces(0).OpenDatabase(gsRWTUPath)

---

Both gdbRWTS and gdbRWTU are dimensioned as Public Database.


------------------
Marty