(Access, 97) How do I open an external Database (1 Viewer)

sysHvV

Registered User.
Local time
Today, 10:09
Joined
Jun 13, 2005
Messages
20
I am trying to open a database form from another database and the first action(s) need to be the opening (or adding) an Artist and an Album in the external Database
For that purpose I am using a dropdown list (with option to add):
Code:
SELECT DISTINCTROW MmArtist.ArtistID, MmArtist.Artist, subMedKind.Groep FROM MmArtist INNER JOIN subMedKind ON MmArtist.QKind = subMedKind.KindID WHERE (((subMedKind.Groep)="Pic" Or (subMedKind.Groep)="PicShow")) ORDER BY MmArtist.Artist;
The form is opened and this is the code I have to do that.
Code:
Option Compare Database
Option Explicit
Dim RS_IN As Recordset, RS_OUT As Recordset, DBIN As Database, DBOUT As Database, WSP As Workspace

Private Sub Form_Open(Cancel As Integer)
On Error Resume Next

    Set DBIN = CurrentDb
    Set DBOUT = WSP.OpenDatabase("D:\MultiMed\MuMedFront.mdb")
    
End Sub
All I get is the possibility to export the files but my dropdown list can not be approached
Any idea what might be going on, and hopefully a resolution to sort out this nightmare?

Thank you very much all for your attention.
 

Users who are viewing this thread

Top Bottom