I have a call log form with a log no.field with AutoNumber type. This form will be accessed by several users, i realise that if user A add a new log half way, user B open another new log and save followed by user A save his log, I only can see the record for user A. Moreover the log no. will lost track like from log no 7 to 9 instead of to log no.8. I think requery can resolve this problem but i am not quite sure how to create Requery, pls help me step by step. Furthermore, how to resolve the lost track for the AutoNumber field.
Thanks.
Thanks.