how do i automatically increment a column's value in a form? that is if i add a new record, one of the columns should have it's value incremented by one. i dont want to use the autonumber field because of the problems it gives later on. i am sure there's an alternative code that can be incorporated in the form. i posted this here a few weeks back but got no where. so i am posting it agai.
thanks for all your help!