From a bound subform, based on an entry, I need to read multiple records from a seperate table and update those records. Since it is a bound form, I can't open a recordset(or can I?) and I can't do multiple dlookups(Or can I?) based on a query. I'm probably overthinking this. Any help is appreciated.
You can do both things you asked. A bound form (or subform) just means that the form is taking care of retrieving data and re-writing it when the user changes data. So you can open as many recordsets and use as many DLookups as needed. But remember, "All things in moderation."
Hope this helps,
Where does the question about DAO or ADO come from? You can use either to create a recordset, and if you are used to using ADO, I see no reason to switch to DAO. If I have missed something here, please let me know what it is.