I'm glad to see you are back on the list. That's great. I need more help
please.
I am using ACCESS 97.
I have a table for holding assets information and I want the Asset Id
(autonumber) to be the same as the table (physical) record number.
I have discovered that on entering data into a new record via a form, if I
ESC out of the new record the autonumber is updated and my physical record
numbers are no longer in synch with my auto numbers. eg if I have
record number 5 (a new record) and autonumber 5 displays as I enter data, if
I ESC before moving onto a different record, and then start entering data
into record number 5 again, it gives me autonumber 6.
Is there any way I can prevent this from happening?
Is there any way I can change the autonumber of record number 5 to "5"?
Thank you very much in anticipation of your response.
Ilona Wright
Adelaide, Australia
[Non-text portions of this message have been removed]
YAHOO! GROUPS LINKS
- Visit your group "ms_access" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
