P
poo via AccessMonster.com
this is what i am trying to do.
i have a form called order and subform called order details.
i have a combo box on order form which has names of customers.when i select the customer ... it should display the related products in another combo box in subform order details.
i am taking the values in the first combo box from the customer query which retrives the customer id and customer name.... also i am taking the record source for the second combo box from the limitproduct query which has productid , productname and customerid.
then on the afterupdate of combo1
ie on cust_afterupdate
form!order!orderdetails!prod.requery
where prod is the name of my second combo box.but it dosent filter anything .also i have connected customer tbl to product table thru custid and then order, orderdetails and product tbls are connected
but i am completely lost
pls help
its urgent
thanx in advance
i have a form called order and subform called order details.
i have a combo box on order form which has names of customers.when i select the customer ... it should display the related products in another combo box in subform order details.
i am taking the values in the first combo box from the customer query which retrives the customer id and customer name.... also i am taking the record source for the second combo box from the limitproduct query which has productid , productname and customerid.
then on the afterupdate of combo1
ie on cust_afterupdate
form!order!orderdetails!prod.requery
where prod is the name of my second combo box.but it dosent filter anything .also i have connected customer tbl to product table thru custid and then order, orderdetails and product tbls are connected
but i am completely lost
pls help
its urgent
thanx in advance