vba to show estimated time in text box

[Delta729]

I hope this makes sense. I just got a request to add a new text box to a form called "EstimatedDuration" and trying to a command button that when clicked, it will insert 30 minutes or #00:30:00" into the box. I'll wind having 5 or six buttons with 30 minutes, 1 hour, 1.5 hours, etc. Basically, this will be used for new projects in my database and for management to click one of the buttons to add an estimated time durations of how long the "think" the project will take to complete.



I'm sure this is really simple, but I'm not much of a vba guy.

Any help would be appreciated.

Thanks

[June7]

Instead of 5 or 6 buttons, could use a combobox or listbox that lists the time choices. Bind to field and selected value will be saved. No code needed.

[Delta729]

Ya, good idea. The manager wanted to click a button, but I'm sure they won't have a problem with a combo box.

Thanks.