Are you able to have 2 criterias in a DLookup statement? Here's the vital info:
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:
Thanks for your assistance!!