This control has saved me a lot of time:

http://www.geocities.com/scirocco_ha/DataControl.htm

All I do is drop it on the form, bind the controls and I can then Navigate, Add New, Delete, Refresh, Search and Save Changes to my recordsets without any other code.