DLookup

[peljo]

have the folowing DLookup function :
If DLookup("Suborder", "Orders") = True Then

I need to refine it, to include only the cases when Suborder = True and Audit = False. How could i do it ?
becasue there are cases when both fields are true but i need only the above one

 

[orna]

If DLookup("Suborder", "Orders","[Audit]=0") = True Then

 

[LonnieJohnson]

Since this is a DLookup and not a DCount I think you will need to include both fields in the criteria parameter of the function...

If DLookup("Suborder", "Orders","Suborder = True and Audit = False") = True Then

Hope this helps.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[TheAceMan1]

How are ya peljo . . .

Have you ever read about [blue]DLookUp[/blue] in VBE help?

[blue]If no record satisfies criteria or if domain contains no records, [purple]the DLookup function returns a Null.[/purple][/blue]

This makes your line of code:

[blue]   If DLookup("Suborder", "Orders") = True Then[/blue]

. . . ambiguous!

Better would be:

[blue]  Dim Cri As String
   
   Cri = "[Suborder] = True and [Audit] = False"
   If [purple][b]Not IsNull([/b][/purple]DLookup("[Suborder]", "Orders", Cri)[purple][b])[/b][/purple] Then[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997

 

[orna]

Dlookup returns only one value and in this case it looks like you need "cases" as you wrote. If so, Dlookup is not the answer.

 

[TheAceMan1]

Howdy orna . . .

The cases (as you put it), are prescribed in my [blue]Cri[/blue] variable and in code provided by [blue]LonnieJohnson[/blue]. I can't seem to grasp your connotation of [blue] "cases"[/blue] . . .

See Ya! . . . . . .

Be sure to see thread181-473997

 

[orna]

I meant to respond to pelgo. When i read the item again, it seams to me that he needs another solution.