You can do this in two ways:
1) You can either do it by use of an ado data control object that you would place on your form.
2) You can code it yourself.
The first way is by far simpler and quicker, but once you get experienced in database programming, you will 99.99% of the time choose the second choice and do the code yourself. This is because code gives you a lot more versatility, and is also more efficient.
I'm not going to get into the details of how to do it exactly. That's why there's a great FAQ in this forum (the second post in this forum called Frequently Asked Database questions). If you're still lost after reading the FAQ, then I can hold your hand and guide you through it step by step.
But seriously, check out the faq, and if you still have questions, just reply to this.