Subform FK won't populate

[AutumnBeds]

Hi All,



Have a slight issue with a subform FK not cascading down from the main form.

It's a many-to-many relationship. The main form should be passing down a contract number in which equipment numbers are allocated to the subform.

Mainform hold "ContractNumber" and the subform is linked to "ContractNumberFK". The ContractNumberFK remains blank when the form is loaded.

Any help is appreciated.

[June7]

Maybe silly question, but have you properly set the subform container control Master/Child Links properties?

If you want to provide db for analysis, follow instructions at bottom of my post.

[kd2017]

Can you post a screen shot of your relationships, the forms, and the subform's data properties tab?

[AutumnBeds]

Hopefully the below will give an idea

[kd2017]

Looks good at first glance. It doesn't automatically populate AFTER you start entering a new row in the subform? Might just want to post the DB file for June.

[AutumnBeds]

Uploaded. The DB is nothing different to what I've done several times before. I'm just scratching my head.Service Trial.zipService Trial.zip

[June7]

The zeroes in controls and #Name? errors are a concern.

Probably should not have fields/controls with 0 as default value.

What is RecordSource for each form - table or query?

[AutumnBeds]

and now all of a sudden it works again?!?!

I restarted multiple times prior to posting as I couldn't get my head around the issue. But now it's corrected its self.

Record sources are from a table, the #name? is due the non controlled box with a dlookup to pull through some reference information. The combo with the 0 is for selecting the equipment to be allocated to the contact.

[June7]

Still recommend not using 0 as default value.

Instead of DLookup, include fields in combobox RowSource (multi-column combobox). Then textbox expression references combobox columns by index. Index begins with 0 so column 2 is index 1:

=[comboboxname].Column(1)

Set those textboxes as Locked Yes and TabStop No.

[AutumnBeds]

Thanks. Will give that a try. Stilling having issues with the parent / sub form. It's stopped working again.

[June7]

Will have to provide db for more help.

[AutumnBeds]

Will have to provide db for more help.

DB attached further up.

[June7]

Sorry, missed that post.

You didn't mention getting error "The LinkMasterFields property setting has produced this error: 'Invalid outside procedure'". frm_Contracts has invalid code in its module - OpenForm command is not within a procedure. Remove this. Now I get different error "error communicating with ActiveX control". I tried removing subform container and recreating and still get error. I tried removing relationships and rebuilding form/subform. Still has issue.Don't set EquipmentNumberFK and ContractNumberFK as compound PK, set as compound index. InspectionNumber should be primary key. This table is giving me hell trying to change PK.Actually, if there are no related dependent tables, this table doesn't even need primary key.

I rebuilt tbl_ServiceJobsJunction and deleted old one. Forms now work.

You have field in tbl_Equipment and tbl_Contracts for Customer which is text, not number. Should be a number (long integer) to save CustomerID. Same for manufacturer. Shouldn't customer address be in tbl_Customers not tbl_Contracts? Should customer even be in tbl_Equipment?

Could just bind frm_Contracts to table instead of query since query doesn't filter or sort or join to another table.

Why is there no tbl_Inspections?

I still don't think should have 0 set as default value for any fields in this db schema.

[AutumnBeds]

June, many thanks.

I rebuilt the table and it worked fine.

The address was put into the contracts as a temporary measure so that I could give the service engineer details of his job. Planning to move this into a separate table.

Also tidied up the other bits and pieces as recommended.

Thanks.