Recording the Time Automatically into a Table from a Form

[Smokey]

Greetings,
I need to brush up on my somewhat rusty Access skills. The problem I face is a very elementary one but for the life of me I cannot figure out how to solve it.

A form in my database needs to record the time a user adds a record and update this in the relevant table. I have created a textbox in the form which is bound to the associated field in the table. This textbox is hidden the locked, so the user will not be able to see or use it.

I am trying to display the time in this textbox when a command button is clicked. Since this textbox is bound to the relevant field in the table, that updates when the textbox's value changes. My textbox is "EntryTime", my command button "Save". Here's the code I currently have:

Private Sub Save_Click()
EntryTime.Text = Time
End Sub
 

This gives me the error "Runtime error 2185: You can't reference a property or method for a control unless the control has the focus". I have tried different variations on my code, but cannot get past this error.

I would greatly appreciate it if someone can shed some light on this.

Thanks.

[MMcCarthy]

Greetings,
I need to brush up on my somewhat rusty Access skills. The problem I face is a very elementary one but for the life of me I cannot figure out how to solve it.

A form in my database needs to record the time a user adds a record and update this in the relevant table. I have created a textbox in the form which is bound to the associated field in the table. This textbox is hidden the locked, so the user will not be able to see or use it.

I am trying to display the time in this textbox when a command button is clicked. Since this textbox is bound to the relevant field in the table, that updates when the textbox's value changes. My textbox is "EntryTime", my command button "Save". Here's the code I currently have:

Private Sub Save_Click()
EntryTime.Text = Time
End Sub
 

This gives me the error "Runtime error 2185: You can't reference a property or method for a control unless the control has the focus". I have tried different variations on my code, but cannot get past this error.

I would greatly appreciate it if someone can shed some light on this.

Thanks.

You can't update a locked control.

Hide it and set enabled to false if you wish but don't lock it.

Mary

[Smokey]

You can't update a locked control.

Hide it and set enabled to false if you wish but don't lock it.

Mary

Thanks for the quick response. I tried unlocking the textbox but still get "Runtime error 2185: You can't reference a property or method for a control unless the control has the focus".

Thanks

[Smokey]

Thanks for the quick response. I tried unlocking the textbox but still get "Runtime error 2185: You can't reference a property or method for a control unless the control has the focus".

Thanks

Sorry, I forgot to add that I can change the value in textbox "EntryTime" with any of its own methods (LostFocus, etc.). Just can't seem to do it with any other control.

[MMcCarthy]

Try this ...

Private Sub Save_Click()
 
   Me!EntryTime.SetFocus
   Me!EntryTime.Value = Time
 
End Sub

Mary