Multiple Users w/autonumber
Posted on 1998-06-17
I have multiple users on a network. I have a customerform, with a main form button to list all workorders in a datasheet view. The problem that has been persistant for the past couple of weeks is the autonumber. Example, If I enter something in a textbox, it automatically generates number 12, for workorder # 12. If I don't refresh or requery my form before I enter in another workorder, then the autonumber missmatches with the record selector on the bottom left hand of the page. Example, Workorder # 12, will be #13 on the record selector. Is there anything I can do so I don't have to keep refreshing or requerying to enter the next record?