Append Query Problems

[S.Dickson]

I have a form that has a combo box thats displays all the suppliers

I then have subform that shows all the products that we buy from them
and how many have been bought and sold therefore work out stock
remaining
I then have a button that runs a append query that opens up a Purchase
order form with a subform that has the products that have to be bought

When i run the query it copys the product code into the Purchase order
Subform with no problem

what i would like to do is on the stock remaing form is be able to type
the amouth i need to reorder in a field then when i run the query it
puts the quantity to be reoreded into the Purchase order subform
If any one could tell me how to do this as the i have no idea how this
could be done

Thanks

[Michael Austin]

S.*******@shos.co.uk wrote:

I have a form that has a combo box thats displays all the suppliers

I then have subform that shows all the products that we buy from them
and how many have been bought and sold therefore work out stock
remaining
I then have a button that runs a append query that opens up a Purchase
order form with a subform that has the products that have to be bought

When i run the query it copys the product code into the Purchase order
Subform with no problem

what i would like to do is on the stock remaing form is be able to type
the amouth i need to reorder in a field then when i run the query it
puts the quantity to be reoreded into the Purchase order subform
If any one could tell me how to do this as the i have no idea how this
could be done

Thanks

I charged a company development cost of $2K to come up with an ordering web
page. All of the calls were made within the database itself (all html and store
procedures). Although, it was not MySQL.

We here, would be more than glad to assist, provided you make the first cut. If
I have to design the whole thing... well, that's why I do consulting on occassion.

--
Michael Austin.
Database Consultant