Automatic record creation

[preveo]

I have two tables; Customers and contracts.

I would like access to automatically create a record in the contracts table when I change the status in one of the Customer Fields from prospective to Customer.
The two tables are linked using the Customer ID field.

Is this possible?

[June7]

Anything is possible with enough code. What you want will require VBA code in some event. The real trick is figuring out which event to use. Maybe the AfterUpdate of control bound to 'the field'. The code could run an INSERT sql action.