opening a mysql recordset

[icemonster]

so i have a 3 tables, table 1 (client info), table 2 (address) and table 3 (FK for table 1 and FK for table 2 - so they would be related), what i want to do is that when i open a record what would happen is the form would be filled with the data pulled by those three tables. how is this done through VBA? thanks on any tips.