VBA loop variable reference in dlookup criteria

[Bill (Unique as my name)]

Is it possible to refer to VBA loop variables from dlookup expression
criteria?

 

[Duane Hookom]

Unique Bill,
Are you scurrying into a new thread to avoid Steve and Doug's question about
your "unconventional" requirements? These guys can offer some sage advice
and at least deserve to get a response from you regarding your requirements
since they have provided some assistance.

You can replace parts of DLookup() like:
Dim intNum as Integer
Dim strSomeValue As String
For intNum = 1 to 12
strSomeValue = DLookup("AField","ATable","NotherField = " & intNum)
Next

 

[Bill (Unique as my name)]

First, I did not want to overly tax Steve and Doug's gracious
generosity. They are most helpful.
Second, the topic I introduced was related, but I thought it deserved a
distinct treatment. The reason I do this is because I occasionally run
seaches on topics. In the future, if I need to look this up again, I
can find the thread easily under a "dlookup" search.
Third, Steve and Doug did get a response from me. Please read the
thread, if you like. I have to step away from the keyboard from time
to time to handle other responsibilities. So I can't answer
immediately.

Your remarks are very helpful as well. Thank you, Duane!