I have a form with a subform in it. The subform is not a datasheet, it's a form. When the user is in the subform and gets to the very last field, if he hits the enter key the record will go to a new one. How can I prevent this to happen. In other words, I want them to only all one record. Thank you,
Sohaila

Try this topic for a solution: http://www.access-programmers.co.uk/ubb/Forum4/HTML/005417.html

HTH,
David R