P
Penstar
I have a subform or Order Details which includes fields OrderID (links to
Main form), ProductID and PackID. Based on the ProductID selected, I want to
use a combo box to look up a PackID from a query. The query is based on
table PackDetail, with fields PackID, Product ID and QtyProdPerPack . PackID
and ProductID are both primary keys. (query links PackDetail table to
PackDesc table contining fields PackID and PackDesc)
I have set the combo box up with mixed results, either it returns all values
on the lookup query, or if I put in a “WHERE†clause, it works for the first
record added but doesn’t on subsequent records (seems to keep initial record
selection from query), and only works when the subform is opened on its own
(i.e. not opened with main form). I also toyed with setting up a button
opening a new form based on the query, but had no idea how to select the
record I wanted and return it to my subform.
I’m really not sure on the best way to solve this problem. Any help would
be really appreciated.
Thanks
Penny
Main form), ProductID and PackID. Based on the ProductID selected, I want to
use a combo box to look up a PackID from a query. The query is based on
table PackDetail, with fields PackID, Product ID and QtyProdPerPack . PackID
and ProductID are both primary keys. (query links PackDetail table to
PackDesc table contining fields PackID and PackDesc)
I have set the combo box up with mixed results, either it returns all values
on the lookup query, or if I put in a “WHERE†clause, it works for the first
record added but doesn’t on subsequent records (seems to keep initial record
selection from query), and only works when the subform is opened on its own
(i.e. not opened with main form). I also toyed with setting up a button
opening a new form based on the query, but had no idea how to select the
record I wanted and return it to my subform.
I’m really not sure on the best way to solve this problem. Any help would
be really appreciated.
Thanks
Penny