Counting Down!

[benwo]

Hi

I have a form which displays which products are on sale but I want it to count stcok orders down, i.e. if there are 10 stock and someone orders 1 I want the system to automatically recognise that there are only now 9 in stock, any ideas? Help really would be appreciated!

Thanks

B

 

[reclusivemonkey]

You've not really given enough information to answer the question here. How do you know someone has ordered an item?

 

[benwo]

if someone has ordered there has to to be some kind of manual intervention. basically if i were to press submit then the table should simply count down 1 or however many had been ordered, does this help?

 

[Matt Greatorex]

How about, under the on-click event, you write a bit of VBA that runs some SQL. Something along the lines of:

Update

Set [Column] = [Column] - 1
Where [condition];

Would that be an option for you?

 

[benwo]

yeh that kinda makes sense, thanks i'll give it a go