Hello Creators,

While using standalone subform (not linked to other form), to find a particular record, we have to iterate through all the rows manually and this is definitely is cumbersome, instead it would be great if we can fetch, update and delete the sub form records just like form

For Eg:

Form_A is the main form and Subform_A is within Form A, it will be great to have a function like

record = Form_A[Subform_A.ID==id]; (this should return only subform field collection not Form_A field collection) or 

record = Form_A.Subform_A[ID==id}; etc.

I see that this feature is long pending. Hence I have created this new topic.