Values carried over from one record to the next

[Adam - Regus]

I hope that I explain this in a manner that makes sense.
On the form that I am working on, I have a box that I've setup to input
the amount of scans that I've done for a client (call it the SCANS
box) and in the next box I've made it automatically input the cost of
the scans. All seems well with the formula in the cost box, but for
some reason, when i go to the next record the value stays in the SCANS
box instead of starting out blank, like I want it to.

As a newbie, I appreciate all your help!

Thanks,
Adam

 

[Guest]

In the forms OnCurrent event, put in the code: me.CostBox = null

That will clear the Costbox everytime you change records.

How are you auto populating the Costbox?

 

[Adam - Regus]

Joel,

Thanks for the quick response. I don't have an OnCurrent event it
seems. I'm running Access 2000, perhaps that makes a difference?
Would OnExit do the same thing?

 

[Guest]

Adam,
You are not looking in the right place =)

When you are in design view, there is a small box in the upper lefthand
corner of the form, right click it and go to properties ->Events.

That is where you will find your On Current event.

HTH
Joel