First, create an ODBC DSN to you MySQL instance (found under administrative tools, Data Sources ODBC).
Then use the Data Form Wizard with the ODBC option...
Start a new standard exe project and goto VB's IDE menu Add-Ins>Add-In Manager.
Scroll down until you see VB 6 Data Form Wizard. Select it.
Then in lower right hand corner of dialog where the frame is with the caption of Load Behavior, put a check in the box next to where it says Loaded/Unloaded. Click OK.
VB's IDE Menu>Add-Ins>Data Form Wizard.
Select ODBC and follow the wizard as many times as necessary to give you examples of each type of display form with each type of code/class/control.
Save this project for future reference.
Then to get rid of the ODBC DSN goto
http://www.connectionstrings.com and see their examples on how to use and DSN Less ADO connection.
Good Luck