Auto complete between tabs in Form

[Hamm]

Hi



I have two tables as follows:
1) Jobs - this lists all jobs completed by a firm
2) Properties - this lists all properties associated with the above jobs, there can be multiple properties under a single job but each job has at least one distinct property record associated to it.

I want a form that has one tab for inputting the job data and a second tab which has a subform for entering the property data. How do i link the property data to the job record? I assume i need to autocomplete an ID number based on the Primary Key of the Jobs form.

I want to be able to use this form to both enter new jobs and find the information from existing records. So when i open the form on Job ID 123 the subform in the second tab shows me the property data associated.

Any help will be much appreciated.

Hamm

[pbaldy]

Normally this is done with the master/child links (properties of the subform control). The subform wizard would have asked about linking fields.

[Hamm]

Thanks. worked perfectly

[pbaldy]

Happy to help.