code to import customerId

[John thomas]

I have a continuous Form for my customers,when i click thecustomers Id I am taken to the customers full form ,from that form I can access four other forms .I have a combo on each of these forms to select my customer .
I need to automate this so that when i open up one of these four forms it imports the customer ID from my customers form Thus doing away with the Combo box

 

[Galaxiom]

Use subforms. The ChildLinkFields are automatically populated with the value from the corresponding MasterLinkFields.

The continuous form will need to be changed to using a subform to display the Master form.

 

[John thomas]

Thanks for your help but i dont want to use subforms surely there must be some code to do this

 

[Galaxiom]

As a code free technique the form can be displayed as a subform inside an otherwise empty main form. The MasterLinkFields can be on any form, not just the one that hosts the subform. Refer to a field or control on the separate original form via the Forms collection.

Otherwise pass the ID to the opening form as the OpenArgs argument in the OpenForm Method. Then use the Open Event procedure to dynamically define the RecrodSource of the form as it opens.