connecting 2 forms with 1db with 2 tbl

[arale]

need somewhelp please

how do i connect 2 forms in vb to 1db with2 tbl

i want to load the data from the 2 tbl to the 2 forms that i made
when the key is id in the tbl.
how do i connect the 2 forms with the key.

[Ianpbaker]

Hi arale

If I understand you correctly, you need to create a module that holds three procedures, one to make a connection to the database (make this one global and to be open all the time the app is open), And the other two to make recordsets for the two tables and populate the correct controls in your forms. Both the procedures take a parameter for the id key. Then once the connection is made, just call the functions with the id key you want and the fields will be filled.

If you need any more help reply back

Hope this helps

Ian