As ranman256 said, this kind of thing is done automatically by Access, when using a Bound Form, which is one of the main reasons for using Access, it allows for rapid development of a database with a minimum amount of coding. You appear to be attempting to use an Unbound Form, not really something for the faint of heart, and certainly not something for a beginner. Why are you taking this approach?
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007