Next Record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with the record navigation buttons at the bottom that let you
to next, last, previous, etc.. It at one time only let one more empty form
show after the last record from the table. But now it just keeps going with
empty data forms. Can someone tell me what could have changed to to this.
Thanks
 
If the record count keeps increasing, but all the controls on the form are
empty, it could be you have a whole bunch of empty records in your table.
Open the table directly and see if there are empty records.
 
This is very strange. The normal situation is for the next and last buttons
to disable when you hit the last record in the recordset. Are these the
standard nav buttons or are they custom nav buttons?
 
Standard

Klatuu said:
This is very strange. The normal situation is for the next and last buttons
to disable when you hit the last record in the recordset. Are these the
standard nav buttons or are they custom nav buttons?
Click to expand...
 
This is most unusual. The only other thing I can think of is to check to see
if there are any events firing that might cause a record to be updated. (I
would start with the form current event).

Are there any required fields in the table? If not, I would pick one, make
it required, and see if you get an error as you continue clicking past eof.
 
Thanks for your help. In the current routine there were a couple lines with
addition and multiplication( don't know if this had anything to do with it
yet). When I put a condition on it to skip when an empty form, things were
fine.
Thanks again!
 
I'm sure that was it. To avoid that, the usual coding is

If Not Me.NewRecord Then
'Do the calculations here
End If
 
Back
Top