N
nick
Hi List.
I'm currently using a DataSheet as the list part of a Purchase Order form. I
have the datasheet in there as a Sub Form. Part of the procedure for filling
out the form is to choose a project from a drop down list in the sub form. I
then use that selection to update the drop down list for the next column
(material group). So... only certain material groups are available to
certain projects.
I've done this by basing the materials combo on a query, and then using the
OnAfterUpdate handler of the Project combo to Requery the materials combo.
Unfortunately for me, this then procedes to requery the Materials Combo for
*every* row... which is a nuisance because one PO might contain items for
lots of different projects.
Is there a way to get it to only update the combo box it the current row...
or am I going about all this in totally the wrong way?
Thank you!
nick.
I'm currently using a DataSheet as the list part of a Purchase Order form. I
have the datasheet in there as a Sub Form. Part of the procedure for filling
out the form is to choose a project from a drop down list in the sub form. I
then use that selection to update the drop down list for the next column
(material group). So... only certain material groups are available to
certain projects.
I've done this by basing the materials combo on a query, and then using the
OnAfterUpdate handler of the Project combo to Requery the materials combo.
Unfortunately for me, this then procedes to requery the Materials Combo for
*every* row... which is a nuisance because one PO might contain items for
lots of different projects.
Is there a way to get it to only update the combo box it the current row...
or am I going about all this in totally the wrong way?
Thank you!
nick.