R
reservedbcreater
hi i didnt use autonumber for my ID
i want to upon form loading for it to take the table data and find that 20
was the last ID# so then take that # and increment it by 1 and then place
the new number (21) into the ID# field on the form when it opens.
the reason being there is already a large amount of data in the tables and
it cant be changed from number to autonumber when there is data on the
table.
i want to upon form loading for it to take the table data and find that 20
was the last ID# so then take that # and increment it by 1 and then place
the new number (21) into the ID# field on the form when it opens.
the reason being there is already a large amount of data in the tables and
it cant be changed from number to autonumber when there is data on the
table.