On hand quantity and location

[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!

 

[David Pawloski]

sorry

you cant do this with microsoft access 2003.

you must upgrade to microsoft access 2004:
http://www.ammara.com/access_image_faq/access_loading_image_dialog.html


HTH

Armando Blanco
Microsoft MVP

 

[Guest]

Thank you.

2003 is the latest release that I know about

 

[Guest]

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.

 

[Guest]

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.