Last Record on form

[rockies1]

How can I tell when my user is at the last record for a bound form so they don't move to the Add Record blank record that is associated with the >* button?

 

[johndoh!!]

I may be wrong (or so my wife tells me) but if you set the "Allow Additions" property to "NO" they will not see a blank record even if they do press the >* button.

 

[rockies1]

You're not wrong...That works.

BUT - I need to allow them to add new records because I have a button that will take a current record and copy it then paste it as a new record. Marking Allow Additions no prevents that.

I just don't want them going to the end and adding one manually...