I have a form on which to print single record I have created a button. However because of natural instinct people go to File > Print and start printing all records. How can I solve this problem.
I don't know if you can disable a single feature like that, in my applications I usually go about thing the other way. Instead of allowing the users everything and disable something I do not want them to do, I disable everything BUT the things I want them to do.
The first of many steps for "user proofing" would be hiding the ribbon, for which the VBA command for this is:
DoCmd.ShowToolbar "Ribbon", acToolbarNo
You need to put it OnLoad of the form which opens first.