Datasheet Subform selection 1

[Javamahn]

I am new to access and would like to know if it is possible to click a record displayed in a datasheet subform and in doing so update that record. The record has fields TrasactionID, ItemID, Customer, TimeOut, and Timein. When the user clicks on the little record selection box all the way to the left of the subform, can I execute a msgbox vbYesNo and then upon Yes update the TimeIn with now()?
I have a decent concept of what I want it to do just not how to do it.

Thank you in advance

 

[ghubbell]

Hi Javamahn,
Well no not really, because you're only event that might fire would be the "on current" event and that might be a disaster. You could however, add a command button just beside or just beside your timein field and in its "on click" event in Visual Basic add this:

If MsgBox("Are you sure you would like to set the time in to ''Now''?",vbyesno+vbquestion,"Time in confirmation...&quot=vbno then exit sub
Me.TimeIn = Now()

Just like that should do it! Gord
ghubbell@total.net