I have two tables, which are both open. My code needs to take some data from the first, find the correct first record (I'll deal with second, third, etc records later) and then, based on whether something is true or not, change a field in the second.
I've set the second recordset as a snapshot as that was the only way I could find that would let me use FindFirst and I really don't want to loop through every record as the table will get pretty big. I think it may be this that is stopping me changing anything in the second recordset, but I'm not sure.
I've attached my code (rubbish though it probably is!) in the hope that someone might be able to point me in the right direction.
I'm awarding 500 points for a quick, working and easy to understand solution so that I can move on to the next bit.