Subtraction Problem

[cliffsimms]

I would like to set a limited number of seats avaiable and have the number of seats subtract every time somone fills out a registration form.

So my form looks like

Course Date Seats

Admins 1 10/1/00 12


Now what I want to happen is when the next person opens the form they see


Course Date Seats
Admin 1 10/1/00 11

 

[Jack Cowley]

Me![Seats] = Me![Seats] - 1 should do it. You just need to place this code so that it will be triggered when the person has definitely committed themselves to taking a seat....

HTH,
Jack