CLearing Few boxes after duplicate

[msp4422]

Hi



I have kept a duplicate button to duplicate the current record but I would like to know how we can make
1) few fields empty and
2) Increment a particular NID field to the next highest number present in the database. ( This particular ID field contains duplicate values too, so Autonumber is eliminated from the options). I am trying to increment that ID to (Current Highest Value in DB for NID+1)

Many Thanks.

[alcapps]

you can use dmax()

=dmax("fieldname","tablename") + 1

if by empty you mean null or ""

me.fieldname = ""