Hello,
I have 2 forms (frmMain & frmFin) and tables associated with them are tblClient & tblFinance respectively. The relationship is 1 to 1 where SSN is primary key in both tables. So for ex. a perticular client can only have one financial record which has there cash, montly income, assets, and so on..
I have it set up so when you first add a new client via frmMain it also creates a blank record for that same person in the tblFinance so then one can go into frmFin and find that person and add/updated their financial info such as their cash, assest, monthly income and so on..
Problem: I am trying to bring up the same record from frmMain to frmFin when I hit the "Financial Info" button on frmMain; however the frmFin opens up from the first record (default). Ex. If the current record is ssn# 222-22-2222 on frmMain then when I hit "Financial Info" button it should bring up that same record from tblFinance and onto frmFin.
How do you do that?
I have 2 forms (frmMain & frmFin) and tables associated with them are tblClient & tblFinance respectively. The relationship is 1 to 1 where SSN is primary key in both tables. So for ex. a perticular client can only have one financial record which has there cash, montly income, assets, and so on..
I have it set up so when you first add a new client via frmMain it also creates a blank record for that same person in the tblFinance so then one can go into frmFin and find that person and add/updated their financial info such as their cash, assest, monthly income and so on..
Problem: I am trying to bring up the same record from frmMain to frmFin when I hit the "Financial Info" button on frmMain; however the frmFin opens up from the first record (default). Ex. If the current record is ssn# 222-22-2222 on frmMain then when I hit "Financial Info" button it should bring up that same record from tblFinance and onto frmFin.
How do you do that?