Updating stock levels using queries

[Ricky1946]

Hello all,
I have an interesting problem for you experts to get your teeth into.
I am creating a stock control database. I have a Parts table (PartsTBL) and an Assembly
table (AssyTBL) which contains parts collected together from the PartsTBL. I need to
update the actual stock levels in the partsTBL from the list of parts pulled through
in the AssyTBL. (In other words I need to extract the items in a particular assembly from
the parts data).
I have used a query to pull together all the parts in a particular assembly in an AssemblyExtractFRM
I have used VB coding to scroll through the items and to look at the quantity to move and take
this away from the actual stock level - but although this works on the screen very well it is not
updating the actual stock in the partsTBL. I have also tried running an update query from
the original select query which still does not work.
Can anyone suggest how I can do this, or is there some other way of doing it?

Regards
Ian

"To say 'thankyou' encourages others."

 

[PHV]

which still does not work
Perhaps some detailed infos would help us to help you ....

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Ricky1946]

Hello phv,
What do you want to know?
Ian

"To say 'thankyou' encourages others."