Copy record and update one field

[chergh]

On the form when you run the query is either your system number or access number blank?

 

[Gegsynz]

I am entering numbers in the SystemNumber and AccessNumber fields, populating all the other fields but have CopyNumber field default value as 1. When I click my Add copy button it creates a new record but is not copying over the SystemNumber and AccessNumber fields nor increasing the CopyNumber to 2

 

[chergh]

Add a line at the very begining of the code that reads:

docmd.save(acform, "form1")

 

[Gegsynz]

Still the same I'm afraid - I will give it away for tonight as its getting towards midnight here and I have a 5am start in the morning. I will go over everything tomorrow night to make sure I have correct. Thanks again for your help and most probably be back here again soon

kind regards

Gerry

 

[jdr1994]

I am also trying to increment a field by 1 when using a duplicate button.
I have tried to put a statement at the end of my event procedure to do the duplicating and it will not work. Here is my statment

serial# = serial# + 1

It just ignores this statement for some reason. Any suggestions??

 

[rob.low]

this thread helped me out today so much thank you guys

the search facility is awesome and easy to use on this site

cheers
rob