I created my own Dlookup routine and I wanted to know if it was a waste of time.
Here is the code. Is there a better more effiecnt way of doing this?
Public Function Dlookup(ByVal Field As String, ByVal Table As String, ByVal Condition As String, ByVal connString as String) As String
strSQL = "SELECT " & Field & " FROM " & Table & " WHERE " & Condition
Dim daDLU As New OleDb.OleDbDataAdapter(strSQL, connString)
Dim dsDLU As New DataSet
Catch ex As Exception