Reduce value of a field

[jball]

I need to reduce the value of a field by one when data is entered in another field. Anyone got any ideas of how to do this in VB.

 

[Guest_imported]

Using a form to enter data,you need to trigger an event
procedure when you've entered the data in the other field.

To do this look in the properties of the other field in the Event section - click into 'On Lost Focus' or 'On Change', and select the 'Event Procedure' then 'Code Builder':

Use the following code:

x=[yourfieldname].value
x=x-1
[yourfieldname].value=x

ok?

 

[jball]

Do I need to replace x with anything, or am I classing it as a variable?

 

[trystanhuwwilliams]

use x as variable,

good luck