gstylianou
Registered User.
- Local time
- Today, 17:42
- Joined
- Dec 16, 2013
- Messages
- 357
Hi, Just a quick question, in order to hold the
How can i write the Public Const Function in order to keep each time the new [LogCustID] from the MainForm? Already i tried the following without results
Option Compare Database
Option Explicit
Public Const cLoggedCustID As String = "Forms!MainForm.LogCustID"
Public Function db() As DAO.Database
'Self-healing database object
Static dbs As DAO.Database
If dbs Is Nothing Then
Set dbs = CurrentDb()
End If
Set db = dbs
End Function
How can i write the Public Const Function in order to keep each time the new [LogCustID] from the MainForm? Already i tried the following without results
Option Compare Database
Option Explicit
Public Const cLoggedCustID As String = "Forms!MainForm.LogCustID"
Public Function db() As DAO.Database
'Self-healing database object
Static dbs As DAO.Database
If dbs Is Nothing Then
Set dbs = CurrentDb()
End If
Set db = dbs
End Function