How to limit Dlookups in the code 1

[netrusher]

Below is the code I am using to fill in a field on my form.
I have many Method types to lookup "001" is the example
below. I also have "002", "003", etc. etc. My question is
Is there away to look up the different method types in
one Dlookup and populate the (Me.Method10) field with the
proper field from the Table or do I have to put in this
code for every different method type?

If DLookup("[Pull_Seque]", "MainEntryQrySelect") = "001" Then
Me.Method10 = DLookup("[Method]", "ReplenishMethodTbl", "[PullSeqCode] = '" & "001" & "'")
End If

 

[PHV]

Something like this ?

Me.Method10 = DLookup("[Method]", "ReplenishMethodTbl", "[PullSeqCode] = '" & DLookup("[Pull_Seque]", "MainEntryQrySelect") & "'")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[netrusher]

Great PHV!!

If you get the chance can you explain how that works?

 

[GingerR]

This is the same response as from your other thread

thread702-1422664



Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[SeeThru]

Also investigave subqueries.

Makes the tables non updateable, but an order of magnitude faster on large data sets.