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.

I had a similar problem....but access seemed to have sorted the table out itself....but then i never used autonumber. What do you want to refresh? the form? or subform?

I only have one table connect to this form. I didn't use subform.