Hi,
- Can I create forms which open sub forms based on the ID of a record selected, which in-turn open sub forms for the selected ID only while connecting to a live SQL table? No linking of tables, no pass-through queries. Only for reading the data, not writing.
- I understand that I need to capture the value of that id as "Me. ID". Store that value in the record set
- Open the subform, and then set the values of the subform with that record set?
Let me know if these are the high level steps that can be done.