combo box with query to update its data

[Saj]

Hi to anyone that can help me

This is a new query I have to one I had earlier but now need to do something
else and cant get it to work.

I have a subform that uses a query that lists in its columns the stockno and
the remaining stock as well as the other bits to it but focusing on first two
in my combo.

Anyway, when I have selected a stock item, I can now query the remaining
stock, in the field quantity being ordered if its greater than the remaining
stock it gives a msg else it creates that orderline and moves to the next
line for a new stockno.

Its at this point, when it moves to the next line to the stockno, when I
select the stockno, I want it to have updated the remaining stock.

eg. if the stock item I ordered had 10 remaining stock and I ordered 5, when
i go to the next orderline, if I select that item again it should have 5
remaining stock not 10.

Can anyone help me with this? tried something called the stockNo.requery in
code but did nothing, so not sure if this is what I wanted or whether I did
it wrong.

Please help if possible...

 

[Saj]

Its Ok... found a way around it to make it work by using the OnTimer for the
forms property.