subform based on combo field

sammers101

Registered User.
Local time
Yesterday, 20:43
Joined
May 11, 2012
Messages
89
I am trying to alter a template (Desktop Product Inventory Database). I have it pretty much set up the way I'd like it, however I am having problems with my PurchaseOrderDetail form.

I'd like to be able to select a category, and have the subreport only show cards from that category. I tried making a query [Forms]![PurchaseOrderDetail]![selected] but that does not seem to be working, not sure why.

The form I am working on is PurchaseOrderDetail and PurchaseOrderLineItems, I included the original versions as well.

I eventually want to delete the supplier box, since I'd like to be able to have more than one category, the supplier box only allows one.

end result example:
category select [drop down box]

list of cards in that category, ability to select some

then I'd like to be able to select a new category, within the same purchase and select more cards

Here is a link, forum wouldnt let me upload, said missing security token? weird
docs.google.com/open?id=0B0RLVeeWAtNxTktXdUNPdHpuSUE

Thanks for any help
 

Users who are viewing this thread

Back
Top Bottom