Subform not filling required info into table

[gumbi17]

I have a database which has been in production for quite a few years, it even made the swap from .mdb and .accdb without losing any of the functionality. Well I just had to export from access to new access to start a new file for one of our projects and now one of the subforms is not adding information into the table. The way the subform functions is it feeds information to the table Lease Tracts, at the same time it has another table Xrf Property Tracts Leases (I didn't pick the name and it drives me nuts too!) When a user starts to add information into the subform the table lease tracts generates an auto number "tracref" which it adds onto the line where the user is inputting the rest of their information. The relationship is set as all alike between xrf and lease tracts to input in both tables, well the xrf lease num1 is being filled in by the master/child setting but the lease num1 on the lease tract is the only field not autofilling. I have been pulling my hair out on this one, and i have gone through every setting to ensure it was the same and all relationships are set the same! Help!

 

[steve21nj]

Did you check the settings from the subform, where it links the master to child?

 

[jdraw]

Further to Steve's comment there is a video tutorial on form/subform
at
https://www.youtube.com/watch?v=YZKN_-P6wck

 

[gumbi17]

It has the master/child setup for the lease num1 on both the main form and also for the linking table xrf property. It does not link to the lease tract lease num1 on the old form, it is exactly how it was on the working subform.