Linking through code

Can we change linking with the subform through code? How?

What do you mean by "linking"?
Do you mean the Master/Child links with the mainform?

Quote:

---

Originally Posted by OBP

What do you mean by "linking"?
Do you mean the Master/Child links with the mainform?

---

YES!

It should be possible, but why would you want to?

Quote:

---

Originally Posted by OBP

It should be possible, but why would you want to?

---

I have 2 fields LNAME & FNAME. LNAME is linked to the subform which displays the corresponding address. But there are cases having no LNAME. In such a case I want the AFTER UPDATE event the FNAME to link with the subform to display the address.

Sorry, but that is poor design.
The master child link should be the same as the Key fields that link the tables, which should be a unique value, usually an Autonumber field or a custom designed value.

Quote:

---

Originally Posted by OBP

Sorry, but that is poor design.
The master child link should be the same as the Key fields that link the tables, which should be a unique value, usually an Autonumber field or a custom designed value.

---

Thanks for your advice. GOD BLESS YOU!!!!!