Update Query Peculiarity - Not All Fields Updated

[boostbyslinky]

I'll mull that one over then.. Uncertain how big this is going to become at this point.. Certainly not 10m, but 10k is conceivable..

As I'm on this voyage of discovery (and feeling a touch lazy), could I select "*" from tblcommitments where ID=42?

 

[boostbyslinky]

To answer my own question... Yes..

Set RS = CurrentDb.OpenRecordset(" SELECT tblCommitments.* From tblCommitments Where ID = 42;", dbOpenDynaset)

Hurrah!
Thanks for your advice. Much appreciated.