Absolutely helped me today! I signed up JUST to thank you!!
After a week trying to find a solution to this exact issue that is NOT Google-able!
I have my forms setting RecordSource based on dropdown table name selection and all was OK once I figured out to set in SubForm datasheet first, but...