I'm looking to create a macro in my 07 database to copy a current record into a new record but leave certain fields blank.
My database is being used to store details of company IT assets and who they are assigned to. At the moment when we get a batch of new machines in we have to create each new record from scratch which can be quite annoying for the end user if there are around 100 laptos delivered.
I've had a look for the past couple of days but i'm getting nowhere fast.
Any help with this would be greatly appreciated