Originally Posted by
didiomm
...but the buttonclick updates all the ConfirmationDate records in the table instead of the record in view...
Are you sure that it is updating all of the Records in the Table...or are you simply seeing the same DateTime in the Control for all Records in the Form? If the latter, then your Control is Unbound...and this is normal behavior for an Unbound Control. The Control needs to be Bound to a Field in your underlying Table to be Record-specific.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007