dlookup function

[samotek via AccessMonster.com]

want to look up in the table products and find the code but only for those
products where the supplier id is 2. My working function is :
=DLookUp("grossprice";"products";"Code=" &

)
How can i attach this condition?

 

[Stuart McCall]

want to look up in the table products and find the code but only for those
products where the supplier id is 2. My working function is :
=DLookUp("grossprice";"products";"Code=" &

)
How can i attach this condition?
[/QUOTE]

Dim strCriteria As String

strCriteria = "Code=" & [Code] & " And SupplierId=2"
=DLookUp("grossprice", "products", strCriteria)

Change SupplierId to the actual name of your field.

 

[BruceM via AccessMonster.com]

DLookup will return only the first instance that meets the criteria, not a
list. For a list, a form/subform would be the way to go. Another choice
would be a query.

want to look up in the table products and find the code but only for those
products where the supplier id is 2. My working function is :
=DLookUp("grossprice";"products";"Code=" &

)
How can i attach this condition?[/QUOTE]

Dim strCriteria As String

strCriteria = "Code=" & [Code] & " And SupplierId=2"
=DLookUp("grossprice", "products", strCriteria)

Change SupplierId to the actual name of your field.[/QUOTE]

 

[ryguy7272]

So you want to see 'only for those products where the supplier id is 2'
Check this out:
http://www.techonthenet.com/access/subforms/link.php

Here's a video tutorial in pre-2007:

Here's a video tutorial in 2007:

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.

DLookup will return only the first instance that meets the criteria, not a
list. For a list, a form/subform would be the way to go. Another choice
would be a query.

want to look up in the table products and find the code but only for those
products where the supplier id is 2. My working function is :
=DLookUp("grossprice";"products";"Code=" &

)
How can i attach this condition?[/QUOTE]

Dim strCriteria As String

strCriteria = "Code=" & [Code] & " And SupplierId=2"
=DLookUp("grossprice", "products", strCriteria)

Change SupplierId to the actual name of your field.[/QUOTE]

--

http://www.accessmonster.com/Uwe/Forums.aspx/access-modules/201004/1

.
[/QUOTE]