Programatically changing the table that DLOOKUP Uses

[chrisbrookeanna]

Hi,

In the DLOOKUP function you specify the table name as a string. How can substitute this string for a variable, that I can set programatically to search different tables. Also for the field names?

Thanks.

 

[chrisbrookeanna]

It alright, sussed it. Thought i'd already tried that...Doh!

 

[David b]

Is it a secret ? - or can you share it
David b

 

[DinanS2]

First create a function:
Function PersTimely(ByVal SFID As String, ByVal sDATE As String, ByVal eDate As String)
PersTimely = DCount("TRANSACTION", "MASTERDTL", "ET < " & 10 & " AND STATUS <> '" & "Reject' AND " & "TRANSACTION LIKE '" & SFID & "*' AND POSTDT BETWEEN #" & sDATE & "# AND #" & eDate & "#")
End Function

Then call the function passing values:
bTimely.Value = PersTimely("SG", mFM, mTo)