I have a button on my switchboard that opens a second database. I would like the second database to open on a paticular form & the last record of the form. Here is the query for opening the second db:
Private Sub Command54_Click()
Dim strDB As String, appAccess As Access.Application
strPath = "\\Fileserver\is_data\Documentation\IT-Private\Scheduling DB\WIP\3-25-10 WIP\"
strDB = strPath & "Schedulingdb_ShipSplitBatch.accdb"
' Create new instance of Microsoft Access.
Set appAccess = CreateObject("Access.Application")
' Open database in Microsoft Access window.
appAccess.Visible = True
appAccess.UserControl = True '