How to set field from VBA on Form Save

F

frank

Hello
I have a data entry form with a label that displays a running timer
hh:mm:ss.
The value displayed on the timer label must be saved to the TimeSpent
field of the table when the form is saved.
How can I set the TimeSpent field in the current unsaved record when
the save button is clicked?

???.TimeSpent = TimerLabel.caption


Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sort fields on continous form. 1
Pause a form that's on a timer? 3
VBA To set folder in MSWord 1
DLOOKUP Save to Table 2
Set form field on double click 3
how to save variable from Form "label" to table 3
Deleting a record from a form 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1

Top