Showing last record

message from =?Utf-8?B?UGFuZ28=?= on 10 May 2004
I have a form named Notes and has a field named [NoteNumber] .when it opens it takes the user to add a new note. But I want to have a testbox where i want to display the last note number. What sould be the code for that?

Any help is appreciated?
 
Arvin Meyer replied to =?Utf-8?B?UGFuZ28=?= on 10 May 2004
Sub Form_Open()

Me.txtNoteNumber= DMax("NoteNumber", "YourTableName")

End Sub

"Pango" <anonymous@discussions.microsoft.com> wrote in message
news:998F8BCB-2C9A-410E-A7F0-427F8FE57E0E@microsoft.com...
opens it takes the user to add a new note. But I want to have a testbox
where i want to display the last note number. What sould be the code for
that?
 

Archived message: Showing last record (Microsoft Access Database)