S
Simon
I am using a continous sub form bound to a main form by an orderid
field.
The sub form ProductDetail carries bound text boxes that indicate an
orderId productId productName and quantity
The tables OrderDetail and ProductDetail are populated by an import
process from a web generated csv file
This source file often contains duplicated products for the same order.
I am trying, with zero success, to conditionally format the product
details in the sub form to indicate the duplicated item, or add an
indicator label that is visible when the OrderId's and ProductId's are
the same so the user can decide whether or not to delete the
line or increase the product quantity.
My result using a basic if statement just ends in all the selected
products for the order being indicated or the label being visible for
all rows.
Is there a way to do this on a line by line basis in the sub form.
Any guidance on this would be much appreciated
Simon
field.
The sub form ProductDetail carries bound text boxes that indicate an
orderId productId productName and quantity
The tables OrderDetail and ProductDetail are populated by an import
process from a web generated csv file
This source file often contains duplicated products for the same order.
I am trying, with zero success, to conditionally format the product
details in the sub form to indicate the duplicated item, or add an
indicator label that is visible when the OrderId's and ProductId's are
the same so the user can decide whether or not to delete the
line or increase the product quantity.
My result using a basic if statement just ends in all the selected
products for the order being indicated or the label being visible for
all rows.
Is there a way to do this on a line by line basis in the sub form.
Any guidance on this would be much appreciated
Simon