N NachoMan Registered User. Local time Today, 08:32 Joined Sep 28, 2003 Messages 56 Jan 3, 2004 #1 Two questions. What's the best way in VBA to determine if the current record is the last record in the recordset? What's the best way in VBA to determine if the current record is a new record (unsaved)?
Two questions. What's the best way in VBA to determine if the current record is the last record in the recordset? What's the best way in VBA to determine if the current record is a new record (unsaved)?
P Pat Hartman Super Moderator Staff member Local time Today, 03:32 Joined Feb 19, 2002 Messages 47,125 Jan 3, 2004 #2 Microsoft Download site This sample db from Microsoft has a form (the unbound example) that uses user-coded navigation buttons. ACC2000: Microsoft Access 2000 Sample Forms Database Available in Download Center To determine if a record is new - If Me.NewRecord Then ..... I find this download site to be better than the one you get from navigating the MS menus - MS Download site
Microsoft Download site This sample db from Microsoft has a form (the unbound example) that uses user-coded navigation buttons. ACC2000: Microsoft Access 2000 Sample Forms Database Available in Download Center To determine if a record is new - If Me.NewRecord Then ..... I find this download site to be better than the one you get from navigating the MS menus - MS Download site
