View Single Post
  #2 (permalink)  
Old November 2nd, 2004, 04:19 PM
JLovell JLovell is offline
Authorized User
Join Date: Oct 2004
Location: Austin, TX, USA.
Posts: 59
Thanks: 0
Thanked 0 Times in 0 Posts

What is the purpose of the .MoveNext? Because you just added a record, you're on the "last" one in the recordset, so a MoveNext will get you No Current Record.

And by the way, if this code is running in the form named [AAA-4to7DigitForm], you can reference the controls using Me:

  !LogStartingRange = Me.StartRange

John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"