Windows 7 32bit 
Access 2007
File is attached.
Working further into my bee hive management app, I am now into the Apiary / Hive Inspection part. So, I have a form, F_Log_Inspection_Entry_Edit that details inspection(s) for a specific Apiary that can include multiple Hives. The main form calls on table T_Log_Inspection_Main. This form is called from a higher level form that limits the results to a specific Apiary Inspection. Getting to that point is not an issue.
The form then has a sub-form, Fsub_Log_Inspection_Detail that calls on a query, Q_Inspection_Detail for its data. When the query is opened by itself with no 'filters', it shows all the Hive Inspections created so far (just two currently). Both Hive Inspections are for the higher level Apiary Inspection dated 7/16/2024, Apiary # 1.
When either of the forms are opened, the sub-form does not show any results for that Apiary Inspection UNLESS, I set the Recordset Type property to Snapshot.
Even when opening the subform by itself, if I go to form view, I would expect it to show all the records in the query but it shows nothing unless it's in Snapshot mode.
Not sure what I'm missing here. The records are clearly returned by the query but when the form is opened standalone, no records when the Recordset Type is set to Dynaset.
I kinda understand the difference between the two Recordset Types. But the query will allow me to make changes to the data so not sur why the form won't work in Dynaset mode.
Any thoughts ??
Reply With Quote
It means you can only add records.
