How to link master and child fields using VBA in MS ACCESS 2003

[Mebrahtu]

I have a main form and sub form. I want to link them using VBA code in Access when a command was pressed. Can you help me please What to do?


Name Of the main form is MainRegister
Fields of the main form are:
CallID, CallerID, OrgID, Zoba, PhoneNO, CallMade


Name Of the sub form is SubfRegister
Fields of the sub form are:
cboCallID1, cboCallerID1, cboOrgID1, cboZoba1, cboPhoneNO1, cboCallMade1

I really appreciate your time.

[TheSmileyCoder]

You can only edit the child/Master relations in design view, or in the forms Open event.

Perhaps if you explain in more detail, WHY you need this, we can suggest an alternative approach.

[Mebrahtu]

What I need this Access database for phone directory in my work.