Thread: Additon?
View Single Post
  #3  
Old April 27th, 2004, 08:52 PM
PC Datasheet
external usenet poster
 
Posts: n/a
Default Additon?

Thomas,

Put the following code in the AfterUpdate event of Field1:

Me!Field2 = NZ(Field2,0) + Me!Field1
Me!Field1 = Null

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com



"Thomas" wrote in message
...
Hello, how can I do this? I have 2 fields. I need to have what is inputed in

field1 be ADDED to(not replaced) to field2. Also, after the update i need to
have field1 empty again. Any ideas?