Format of temporary variables

K

KenB

I have a pointer stored in TempVars!MyIndex
Within DLookup( or DSum( references to TempVars!MyIndex work fine
but
IIf(tblField = TempVars!MyIndex, does not work.
As a work-around I tried this:

Dim NewIndex as Integer
NewIndex = TempVars!MyIndex
IIf(tblField = NewIndex, and found it works well.

So just what is the difference between temporary variables and numeric table
fields? ---- Ken
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Temporary Variables 1
DLookUp for an Alphanumeric Record 3
Public Variables 0
Store values in variables based on count 3
Use of variables in a query? 1
Excel VBS time difference functions<[email protected] 0
Selecting next record in dynaset and assigning to variable 1
Why does timeGetDevCaps fail? 2

Top