New record on linked for CustomerID field blank... (1 Viewer)

[Carpetwarehouse]

Ok i have a customer form with a button that opens a job form the customer and job tables are linked with a customerid field.

When the job form opens the records are filtered to show the ones matching the customerid displayed on the customer form.

Problem is when i then go to add a new record on the job form it leaves the customer id field blank instead of knowing to pass on the customer id ???

Thanks

 

[Isskint]

Your job form is filtered to show jobs for the current customer. However when you hit New it does not keep the customer ID. There are a number of solutions;

1. When creating a new job, use some code to insert the value of the customer ID
2. On the Job Form, set the CustomerID control's Default value as =Forms!CustomerFormName.CustomerID
3. make your job form a subform of the customer form.

 

[Carpetwarehouse]

Thanks alot number 2 worked, which was the one thing i thought to try but i must of not linked the field up right.