I have the following formula "LP." + Project_autonumber, where Project_autonumber is an autonumber field. when I create a record it works fine but when I subsequently edit the record the data value changes to eg LP.null   any ideas why???

thanks in advance