Preventing record selector, creating new record

[BAzZ]

Hi All,
I have a form that when loads, runs some VBA on the "On Current" event.
Some of that code, fills in text boxes, with concatenated (?) strings.
So every time I use the record selector and get to the end of all the records, the "On Current" fires adds the concatenated string (even if it's empty), and that then becomes a new record! Is there some way i can prevent this, but still keep the "On Current" event, some type of logic I could run before the concatenations etc.

Any Help would be appreciated.

Cheers

BAzZ

 

[pono1]

If I'm following you, then something like this should help solve the problem.

If me.NewRecord then
   do something
Else
   do nothing (or something else)
End

Regards,
Tim

 

[BAzZ]

that was it I new it must have been fairly straight forward.

Cheers!