Have a property like...
Code:
Public Property Let DatabaseName(Optional byval strName as string = vbNullString)
If Len(strName) = 0 then
'Load form or Common Dialog to select file
Else
'Set database name equal to strName
End If
End Property
This however isn't the correct way. I think I know what you're getting at, but I don't know exactally how to implement it in the correct way, like the database name...
I will have a look for you though. I think I saw something in the General VB Questions forum on this exact topic last week...