Next record

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

Guest

I'm using a form with navigation buttons enabled...When I click next record
button right arrow) and I'm at the end of the table will add an empty record.
If I click next record 10 times will add 10 blank records.
How can avoid adding a new record every time when I click next?
 
Adidre1 said:
I'm using a form with navigation buttons enabled...When I click next
record button right arrow) and I'm at the end of the table will add
an empty record. If I click next record 10 times will add 10 blank
records.
How can avoid adding a new record every time when I click next?

Do you want to eliminate all new record creation or just multiples?
 
It sounds as if there is a "before insert" event that is loading some
type of information into the record so that it is actually saved.

Is there some field that you absolutely need - must have filled in?

If so then you could either change the table definition to require that
field or add logic to the form to test for null in that field and
cancel the movement to the next record and or force focus to that field
until it is loaed..
 
Back
Top