Unanswered: how fieldname can be increase by one no?
I have one field name that need to increase (by plus 1 with existing number) after one command button clicked.the result is when I click cmd button, the field name will plus one with existing number...any suggestion?
Sorry can I just check this is the name of hte field you want to increase not the value held i the field?
It's doable, just, You'd have to close the contavt with the table, and use code to perform an ALTER TABLE command. Where it gets messy is if you want to keep the data that's in the field. Access doesn't permit the simple changing of a filed name with the data in it (or it didn't up '97) and you have to add a new field, delete the old one and somehow copy the data from one to the other. Very messy. Avoid it if you can!