Next record navigation button keeps creating new records! 1

[SeadnaS]

If I use the navigation buttons at the bottom of my form to go to the last record, and then click the next record button it doesnt pop up the usual message say there are no more records! It creates a new record! I can keep doing this as much as i want it seems! I can't for the life of me figure out what I did to cause this!

Any help very much appreciated!

 

[SeadnaS]

Figured it out. I had a few lines of code in the on current event of the form that made the value of a few text boxes = Null, I removed them and now its OK again.

So, is there a way i can clear these text boxes when moving to a different record without affecting the navigation buttons?

 

[missinglinq]

Do you need these Textboxes set to Null when moving to Existing Records but not when moving to New Records? If so, simply test for a New Record and if it is not, execute your assignment code:

If Not Me.NewRecord Then
Me.TargetTextbox = Null
End If

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[TheAceMan1]

How are ya SeadnaS . . .

[blue]I had a few lines of code in the on current event of the form that [purple]made the value of a few text boxes = Null[/purple][/blue]

Normally, when you move to the [blue]AddNewRecord Line[/blue] (the one with the asterisk [purple]*[/purple]) the nex record button disables/dims (that disabled look). However ... since your writing to a new record, it goes into [blue]edit mode[/blue] and the [blue]AddNewRecord Line[/blue] moves down for the next record. Unless your using [blue]defaults[/blue] the [blue]AddNewRecord Line[/blue] should always be clean before you enter data.

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]