Append Query Problems

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
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

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


Re: Append Query Problems wrote:

Quoted text here. Click to load it

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

Michael Austin.
Database Consultant

Site Timeline