Form Updates Table, But Table Doesn't Update Form

[jammy1812]

Hi guys,
Have an issue with my Database.

I have:
TblOrderDetails
FmOrderDetails
(There are several other forms and tables, but I'm focusing on this one at the moment.)

Whenever I add data into the Form, it will update the table as expected.
However when I add data into the Table the Form doesn't display any of the data.

I need to import several hundred records from Excel into the Table as I'm moving systems, but for some reason it's not showing up.

I've tried importing into the Table, as well as tried manually entering data, but nothing seems to work.

Any help?

 

[JHB]

What happen if you close the form and open it again?
Do it now show the right data?

 

[jammy1812]

I've uploaded my Database for your records.
As you can see I've added data into the table, but its not appearing on the linked form.


Edit:
Hi JHB, Yeah I've tried refreshing/opening closing but nothing updates.

 

[jammy1812]

So I've done a bit more tinkering.
I've discovered that the issue is only present on the following 2 sections:

TblOrderDetails and FmOrderDetails
TblCircuit and FmCircuit

These are the only 2 tables/forms with foreign keys and joins in them...could this be the issue? If so, any help on how to rectify this would be appreciated.

 

[JHB]

One thing I saw was that the form "FmOrderDetails" was set to only data entry, (so here you'll never se any other data as them you current enter , change the property for the form).
You can not expect to see data in the form before there is data in all tables that are linked together in the form's RecordSource because the linking type is set to "Only include rows where the joined fields from both tables are equal". Change it to "Include ALL records from tblOrderDetails ..."
In the table "TblCircuit", there was no data in the table, but I think you have to change the linking type i the form as described above.