Next Record : Want it to stop going through next blank record reco

[Guest]

Hi

on my forms, every time i click next record, it obvioulsy goes to the next
record, but when there no records there, it will keep goin through blank
records when clicked on next record. and when i close the form and re open,
it would have created new blank records somehow!

is there anyway i can stop it doing this? so as soon as the records finish
it will stop going through next blank record and stop creating new blank
records!

 

[Lynn Trapp]

Do you have some code in the Current or BeforeUpdate that is putting a value
in some field that is not visible on the form?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Guest]

Hi

i started to mess around with it, and got it sorted. all it needed was a
Required field input, so a field would be required before going to the next
blank record!

Thanks!