One form field serve two jobs?

[mellowyellow]

Hello all, I have an Access database for a project I'm currently working on.
It's a simple stock control system which records sales and the level of stock.

How can I set up a form that when you click a button, two queries are run?
I want to add a record to the 'Sales' table but also modify the 'Stock' table to edit the 'Current Stock' field.

Any ideas?
Thanks

 

[Rich]

http://www.access-programmers.co.uk/forums/showthread.php?t=105854

 

[mellowyellow]

Darn, so could you recommend a method of recording sales and updating stock levels as one process?