On hand quantity and location

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using Allen Browne "On hand quantity" and I works great.

The same item can be at 20 different locations.

When I do my invoices I want to select a location with available items using
a combo box.

I can show a "summary" of the locations and the quantity available at those
locations in a sub form linked by the "itemID".

My problem is that I need to "restrict" the 'location combo box' to only
those with available items.

I can't "link" the results of my sub-form to the location field with out
showing all items in the inventory, instead of only the items I'm working
with.

Thank you!
 
Spammer, ignore it, there is no 2004.

Use the rowsource property of the location combo to return only locations
with items available.

SELECT Location From ItemTable Where LocationQty > 0

When an item is selected, requery the combo. Since I don't know your data,
I can't give you the exact code, but this is the basic idea.
 
Thanks!

My SalesDetail form has an ItemID field linked to my product Item ID table.
Y use a query to calculate the "on hand" quantity Received - Sold
When I place a sub-form using this query, It shows the quantity on hand for
the Item because the sub-form is linked by ItemID.

When I use the query as recordsource for the 'location' combo field of my
SalesDetail, it shows all the locations available for all items. I don't
know how to link the query to that specific record-> ItemID, so it shows olny
the locations for that item and not for all items.
 
Back
Top