Hi, I have 2 forms in 2 databases:
1) db1-2, form: "loan", text field: Loan Number
2) db2-2, form: "loan2", text field: Loan Number
Form "loan" has button "Form"
Using button "OnClick" event I ask you to do the code similar to
Note: please don't be confused that provided sample databases are simple. I will need to integrate provided code to more complicated databases:
Note 2: Please do not provide answer based on linking tables only. I can do it myself. You can link tables. However, I need code which references record from one form to another in different databases.
For simplicity db1 and d2 have identical data