Now here's the deal. If I enter the data through the form this query will show that record in the subform. but if I enter the data directly into the table those records will not show up in the subfrom.
I have even entered a record in the form and then copied the record and pasted it again in the table and it will only show the one record entered through the form.
Very strange. If anyone has a solution it would be greatly appreciated.