| | |
|
|
|
Auto Number or any method |
| message from suzie on 5 May 2004 |
I have created form using Frontpage and database is
Access. When the user enter data from the form, i want
database to generate id in sequence format. In that case I
need to set the id to autonumber.
Can I use other method or coding to give the id of each
data? I still want to use numbers as the id.
TQ
|
| =?Utf-8?B?SmFja2llIEw=?= replied to suzie on 6 May 2004 |
Me!IDField.DefaultValue = Nz(DMax("[IDField]","tblInformation"),0)+1
Hope this helps.
|
|
Archived message: Auto Number or any method (MS Access Error Message)