Multiple criteria in DLookup

[crowegreg]

Are you able to have 2 criterias in a DLookup statement? Here's the vital info:
Expr: OnHandQty
table name: ICPartWarehouse
criteria: FKICPart = me.FKICPart and WarehouseNumber = 3
both FKICPart & WarehouseNumber are fields within the table

Here's what I have so far:
=DLookUp("OnHandQty","ICPartWarehouse",????)

Thanks for your assistance!!

[June7]

You can have has many criteria as you want, as far as the ControlSource string length limit will allow. If FKICPart is a number datatype, remove the apostrophe delimiters. The Me qualifier is VBA, can't use in Access.
=DLookUp("OnHandQty","ICPartWarehouse", "FKICPart ='" & [FKICPart] & "' And WarehouseNumber = 3")

[crowegreg]

I receive an error. Both FKICPart and WarehouseNumber are fields within the table, and both are numeric. In the search criteria I need FKICPart = text190 and WarehouseNumber = 3.

[RuralGuy]

Try:
=DLookUp("OnHandQty","ICPartWarehouse", "FKICPart = '" & Me.text190 & "' And WarehouseNumber = 3")

[crowegreg]

Thanks for the assistance. I've been testing different things, and nothing has worked yet. I pasted your suggestion, and I had to change WarehouseNumber to WarehouseNo. Within the field I'm receiving #Name? If I trouble shoot with only using 1 criteria, it works properly. When I add the second criteria, I receive the error message. When I only use 1 criteria, I'm manipulating the data so I only have 1 match.

[crowegreg]

I should also write that text190 is a Dlookup. Here's what is in text190, =DLookUp("SKICPart","ICPart","ID ='" & [ISBNBW] & "'"). Within the dlookup that I'm having the problem, all fields are numeric. In the Dlookup that is in text190, SKICPart is numeric, and ID & ISBNBW are text.

[crowegreg]

After spending many hours on this with no solution, I decided to write VBA behind the form. It works great. Maybe there is a problem within Access 2010 an multiple criteria in a DLookup.

[June7]

No, multiple criteria works fine. However, my DLookup used a field in the form's recordset as criteria. Never tried a DLookup that used the results of another DLookup. Did not test but problem must be with that.