VBA Problem

[CJ_London]

If you do not want anyone to manually change the time of a text box, set the enabled property to YES and the Locked property to NO.

shouldn't that be Locked=Yes?

[andr3ahh]

In your table, you have fields
Allertamento (ATT)
Partito (Part)
Target (TARG)
Target_Ospedale (T_H)
Ospedale (OSP)
Libero (LIBERO)

Form "Richieste" is in Continuous Forms view and each record has 6 date/time fields.
The label must be bound to the text box.

Lets say the field name is "Allertamento" and the name of the bound text box is "ATT".
(The name of the field in the table is "Allertamento" and the name of the Text box is "ATT")
In the double click event of ATT, the code would be

Private Sub ATT_DblClick(Cancel As Integer)
    Me.ATT  = Time()
    Me.Refresh
End Sub

For the field name "Partito", the bound text box name would be "PART".
In the double click event of "PART", the code would be

Private Sub PART_DblClick(Cancel As Integer)
    Me.PART = Time()
    Me.Refresh
End Sub

The rest of the time fields are set up with the same code.


If you do not want anyone to manually change the time of a text box, set the enabled property to YES and the Locked property to NO.

I've already tried that. It says "Method or data member not found"...

[ssanfu]

shouldn't that be Locked=Yes?

Ack!! I hate when I do that .... good catch Ajax. Thanks for correcting me.

(and I edited the post)

[ssanfu]

I've already tried that. It says "Method or data member not found"...

Don't know what to say. It worked for me......
Or maybe I still don't understand what you want.....

You could post your dB with just a few records.........

Try this demo.