new record on linked form not working as it should... (1 Viewer)

[Carpetwarehouse]

Hi

This relates to 2 tables a customer and a jobs table both linked by [CustomerID].

I have a button opening the jobs form from the customer form showing jobs for that customer.

When i go to add a record the [JobID] field on the jobs form shows (New) but the [CustomerID] is not passed over and the field is left blank.

Am i right in thinking i can go to the properties of this field and under source select [CustomerID] from the Customer form or is that the wrong way to do this?

Thanks

 

[JHB]

Use the form's open argument (OpenArgs) look in the Help file, how you pass a value using OpenArgs and how you get the value in form you open.