Moving to Next Record

[chrisjrice]

How do I stop Access from accessing a new record when I forward past the last record within a form?

I currently have icons set up to allow a person to move bacward and forwards through the records. I want the form to stop at the last record not move into a blank one.

Help would be much appreciated.

Chris

 

[IMO]

In the Forms Properties set Allow Additions = No

IMO

 

[chrisjrice]

I also have an Icon which you click on to add a new record. If I set this form property to no, will that disable the add icon as well?

Many thanks for your help.

 

[IMO]

In the OnClick event of your Add Record button put this code...

Me.AllowAdditions = True
DoCmd.GoToRecord , , acNewRec

IMO

 

[chrisjrice]

Thanks very much that worked pefectly.

Chris