Random data fields missing from records on form

[PatrickJG]

The form "Main Receiving Form" is missing just certain fields of random records. The data is there in the table. There are linked tables, but if it works for one record why wouldn't it work for the rest. This something that has started to occur recently. Attached is the dB. I have performed repairs, re-indexed but nothing is working. Any help is appreciated.



To see the problem, open the for "Main Receiving Form" and just start scrolling down to see the missing data. I confirmed the data is in the tables.

Thanks,
PG

[June7]

Are you talking about the Product combobox? It has a RowSource with a filter criteria of Approved_Product=True. This means records with a product ID that is no longer approved, will not show the alias Product_Name because it is not included in the combobox list. This is why filtered combobox lists that have alias do not work well in continuous or datasheet forms.

[John_G]

It's not random.

Your query Query_Product_Lookup only shows records from tblProduct where Approved_Product = True. However, your table tblReceiving_Main contains values (49 and 59 are two of them) in the Product_ID field that refer to records in tblProduct where Approved_Product = False, therefore the lookup finds no data in the combo box.

"Random" missing data like that is very rarely truly random - there is usually a reason, but it can take a lot of digging to find out what that reason is.