Hey all! First post, but I am obliged to you all for the helpful posts I've mined over the last year... 
I have an Access Form which needs to work with information coming from multiple RecordSets. One of these is set as the Form's Record Source. That one is no problem. I also figured out how to do reads from RecordSet number two and pop them into the form using DLookup.
When it comes to being able to UPDATE records in the non-Record Source database, I am stumped.
So far, the best I've been able to come up with is a messy set of VBA subroutines. It seems like this is something that would hapen often enough, but I've not found much when searching about.
Any and all help would be much appreciated- thanks!
Cheers!
Aaron
I have an Access Form which needs to work with information coming from multiple RecordSets. One of these is set as the Form's Record Source. That one is no problem. I also figured out how to do reads from RecordSet number two and pop them into the form using DLookup.
When it comes to being able to UPDATE records in the non-Record Source database, I am stumped.
So far, the best I've been able to come up with is a messy set of VBA subroutines. It seems like this is something that would hapen often enough, but I've not found much when searching about.
Any and all help would be much appreciated- thanks!
Cheers!
Aaron