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):
The form is opened and this is the code I have to do that.
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.
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;
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
Any idea what might be going on, and hopefully a resolution to sort out this nightmare?
Thank you very much all for your attention.