I had developed my application on 2013 version originally and last year moved to 2016 version of Office.
To pick up data from a form directly I was using following code without any problem:
form_name of open form![name of sub-form].form.recordset
I was able to cycle through the records using loop method without any problems.
After moving to 2016 version, the same program is working without any problems.
However, I am trying to use exactly the same method for another event in different project, and it gives error "424 - object required".
I also tried to use for main form itself as recordset (no sub-forms) and same error comes up.
Looks like VBA in 2016 accepts what was written earlier in 2013 but anything new gives error.
I have checked everything carefully including property of the form, etc., but cannot get it working.
Any ideas?