If you are using VB 6, I'd recomend that you go into the add in manager (under the add-ins) menu and load the data form wizard. You can use the data form wizard to create a data form that uses either a ADO data control, or ado code. The form it will create will give you ideas on how to code your form. It won't have all the bells and whistles but it will be fully functional (It's actually not a great user interface, but it gives coding ideas).

When you get away from using just the data control you will have a form that is MUCH more functional, but then you will get into many more issues. The coding will get MUCH more comples especially if you build it to be used in a multi user enviornment.