Subform not filling in info in 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!

[June7]

Hard to analyse from pictures. If you want to provide db, follow instructions at bottom of my post.

[gumbi17]

OK I extracted out a lot of the forms that have nothing to do with this problem and get it down to the 2mb requirement!

[gumbi17]

Here it is!

[June7]

First thing I see is the Property Num combobox on [LINKS99 LEASE BASIC TRACTS SUBFORM QUERY] form has No Such Field error. But I doubt this contributes to issue.

I don't see how this form could ever have worked as you describe. Forms can enter data to only one table. The primary recordset for the query the subform is bound to is [Xrf Properties, Tracts, Leases] not [Lease Tracts]. This is indicated by the join type 'Include all records from Xrf Properties ...' This form is setup to create a new record in [Xrf Properties, Tracts, Leases]. This form has a combobox to select a TractRef value but this will not generate a new TractRef value in [Lease Tracts] table. This subform does not and should not and cannot feed data into table [Lease Tracts].

[gumbi17]

So what would I need to do to have it start updating onto the Lease Tracts? As well as keeping the relationship with the Xrf Prop! I will have to go back to one of the older one and condense it so you can see what it was doing.

[June7]

Explore the NotInList event of combobox. If desired tract record not in the TractRef combobox, open form to enter new tract record, the combobox list will update and record available for selection.