S
Simon
i have a Continuous Forms that is based on a query
this form disply the products that were placed in the order with the
quantitys
on the form i then was going to add a text box that i would type in the
quantity i am sending out in the parcel. once i had type in the
quanties of each product ther were going to be despatched i was going
to run a append query that would put the product code, and despatch
number as well as teh number i had type into teh text box on the form (
the number to be despatched)
(im not sure if this is the best way to do it)
the problem i have if i put a text box on the Continuous Forms then
view it and type a number in it, it automatily set the text box for
each recodred to the same number
Is there a way to get around this
overall what i am trying to do is create a dispatch based on the order,
there for if we are out of stock most of the order will be sent out and
then the reaming amout at a later date
this form disply the products that were placed in the order with the
quantitys
on the form i then was going to add a text box that i would type in the
quantity i am sending out in the parcel. once i had type in the
quanties of each product ther were going to be despatched i was going
to run a append query that would put the product code, and despatch
number as well as teh number i had type into teh text box on the form (
the number to be despatched)
(im not sure if this is the best way to do it)
the problem i have if i put a text box on the Continuous Forms then
view it and type a number in it, it automatily set the text box for
each recodred to the same number
Is there a way to get around this
overall what i am trying to do is create a dispatch based on the order,
there for if we are out of stock most of the order will be sent out and
then the reaming amout at a later date