Continuous Forms text box problem

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
 
V

Van T. Dinh

That is the normal behaviour of an unbound TextBox on a Subform.

You will need to bind the TextBox [txtQuantity] to a Field in the Subform's
RecordSource to have different values in different instances of this
TextBox.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top