This may be a bit of information overload but i want to leave no stone unturned since this is a project I've been working months on to run into the same issue I was trying to avoid. Per the forum rules i have posted a similar question https://answers.microsoft.com/en-us/...=1585439828738 .
so back to the issue at hand I have a main form that is set to control by the tblFeedstockLotData there is subform controled by tblHardnessResults and a nested subform controlled by sample results.
here is a screenshot of the relationships.
and here is a screenshot of the form
the most puzzling thing to me is it was working and I don't know why or when it stopped it just did and I wish I had more information on that.
now more information on the issues ive found.
1: there is no data to show so therefore it comes up blank
2: even when i add a batch number to the main form save it and close it it still doesnt create a blank line in the hardness results subform or the sample results for me to add data.
3 if i go into the tables directly and add a feeddstock/batch number even if theres no data then everything will come up for me.