SteveL13
asked on
How prevent addition of record when user clicks a right arrow on a form
I have a for which does not have the navigation buttons displayed due to a user preference. But the form does have a "homemade" right arrow which takes the user to the next record. But when they get to the last entered record I don't want them to be able to add a record by clicking the right arrow one more time.
Kind of like: (which of course isn't correct)
If me.lastrecord = true then
exit sub
end if
Kind of like: (which of course isn't correct)
If me.lastrecord = true then
exit sub
end if
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Or you can set the Form's AllowAdditions property to No.