Timestamp on Buttonclick

[didiomm]

Hi All:

I currently have a table that feeds a form with a column called "ConfirmationDate". Each time a record is updated in the form, I would like a button called "confirm" to be clicked. I would like a textbox on the form to populate with the date and time of the buttonclick. Each corresponding record in the table would also be updated with its respective buttonclick timestamp in the "ConfirmationDate" column. I tried doing this

Private Sub cmdConfirmationDate_Click()
Me.cmdConfirmationDate = Now()
End Sub

but the buttonclick updates all the ConfirmationDate records in the table instead of the record in view.

I'd appreciate any ideas/help.



Thanks!

Didiomm

[ssanfu]

Does it have to be a button click??

I would try the "Form_BeforeUpdate" event.

Lets say you have a table with a field named "ConfirmationDate".
The table is bound to a form. On the form has text boxes bound field. One of the text boxes is bound to the field "ConfirmationDate". This text box is named "dTConfirmDate".
The form is in Continuous Forms view.
Each record is one line in the form.

In the "Form_BeforeUpdate" event, you would have code like

Private Sub Form_BeforeUpdate(Cancel As Integer)
        Me.dTConfirmDate = Now()
End Sub

When you add a record or edit a record, the Before Update event will fire and will add the current date/time to the text box, then the data is saved.

(I works for me in my dB.......)


----------------------------------------------
BTW, in your code you are trying to set the button to Now(), not the control/field.

Private Sub cmdConfirmationDate_Click()  '<-- the name of the button 
    Me.cmdConfirmationDate = Now()
End Sub

[Missinglinq]

...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)>

[didiomm]

Ssnafu: good catch, thanks. And, it doesn't have to be a buttonclick. I maintained the single form view and used your suggested code and it seems to work. Thanks.

Linq: you are right. During testing, I was making changes so quickly, it didn't seem the timestamp was registering for each record. But it seems they are - I double checked the seconds portion of the date/time stamp in the actual table to confirmed this.

Thank you both, you've been helpful!

[Missinglinq]

Glad we could help!

Linq ;0)>