Problem with Form which contains two Subforms

[AntonRSL2016]

Good morning,

I have the following structure:
Form Frm_Production_Main which has two Subforms
SbFrm_Production_Sub_MLCD and
SbFrm_Production_Sub_TB.
These forms are linked to tables:
Tbl_Production_Main
Tbl_Production_Sub_MLCD
Tbl_Production_Sub_TB

The Record Source for the Form is the following:

SELECT Tbl_Production_Main.*
     , Tbl_Production_Sub_TB.BC_ID
     , Tbl_Production_Sub_TB.Traceable_Batch
FROM   Tbl_Production_Main
       INNER JOIN
       Tbl_Production_Sub_TB
  ON   Tbl_Production_Main.Batch_Card_ID=Tbl_Production_Sub_TB.BC_ID;

I notice that Tbl_Production_Sub_MLCD is not mentioned?!

I built the form structure from a copy of previous structure that did not have subforms.

My problem is that new records that I add currently are added to the tables, but cannot be displayed in the form after entry? I know I must have done something wrong but I am not sure what.

Any advice would be much appreciated, thank you.

Anton

[AntonRSL2016]

It's ok, I've worked it out, there were entries missing in the sub table!