J
Jac Tremblay
Hi,
In my LineOrders sub-form, I have two combo boxes. The first is to select
the type of product and the second, the product from the list of products
that should be updated from the 1st selection. But my second combo will not
update to what I want. I tried to change the Row Source property but there
are no apostrophes in that string so I do not know how to write the new query.
Actually, I have this (in the Row Source of the 2nd combo):
SELECT tblProduit.IdProduit, tblProduit.IdTypeProduit,
tblProduit.Description FROM tblTypeProduit INNER JOIN tblProduit ON
tblTypeProduit.IdTypeProduit=tblProduit.IdTypeProduit WHERE
(((tblProduit.IdTypeProduit)=lngIdTypeProduit)) ORDER BY
tblProduit.Description;
In this text, the variable lngIdTypeProduit holds the selected Product ID
from the 1st combo.
Is there a way to do that without programming?
If not, I will program it.
Thanks for any help.
In my LineOrders sub-form, I have two combo boxes. The first is to select
the type of product and the second, the product from the list of products
that should be updated from the 1st selection. But my second combo will not
update to what I want. I tried to change the Row Source property but there
are no apostrophes in that string so I do not know how to write the new query.
Actually, I have this (in the Row Source of the 2nd combo):
SELECT tblProduit.IdProduit, tblProduit.IdTypeProduit,
tblProduit.Description FROM tblTypeProduit INNER JOIN tblProduit ON
tblTypeProduit.IdTypeProduit=tblProduit.IdTypeProduit WHERE
(((tblProduit.IdTypeProduit)=lngIdTypeProduit)) ORDER BY
tblProduit.Description;
In this text, the variable lngIdTypeProduit holds the selected Product ID
from the 1st combo.
Is there a way to do that without programming?
If not, I will program it.
Thanks for any help.