Failure to return data from multiple tables in subforms or select queries

[mcchieftan]

I have two tables, tblProducts and tblStockCheck that are related by the field code which is the primary key of tblProducts. The relationship is one to many as the same record form tblProducts may appear many times in tblStockCheck.

frmStockCheck enables users to enter information into tblStockCheck. frmProducts displays records from tblProducts and appears on frmStockCheck as a subform, allowing users to verify that the item they have identified is correct and already exists in tblProducts.

qryViewLastSC is a select query that displays all of the last month's stock check data from tblStockCheck accompanied by the related information from tblProducts based upon the field code.

This was all working fine until last week when the related data stopped being displayed, either in frmStockCheck or qryViewLastSC. I've been reading everywhere but I can't get it to display again. Does anyone have any ideas?

Thank you for your time,



qryViewLastSC returning data from tblStockCheck but not tblProducts




qryViewLastSC in design view





frmStockCheck failing to return related data from frmProducts

[Homegrownandy]

zip your database and attach it. Click the advanced option when making the post and manage attachments.

[mcchieftan]

Hi! I managed to fix it by copy pasting tblProducts from a backup and I don't have a version of the buggy database
I was hoping it was something obvious like an incorrect property.
Thanks anyway

[Homegrownandy]

Compact and repair could work in future.

[mcchieftan]

Thanks for the suggestion