Enter current date and time into subform field

[tonybrecko]

I have a subform with a field which, when clicked, I would like the current date to be inserted.

I want to keep this form as simple as possibe.

I got this code to work from the sub form:

Private Sub StartTime_Click()
Forms!frm_TimeLogSub![StartTime] = Now()


End Sub

but when I open the main form and click on the field I get a run-time error the the application can not find the referenced form.

Any help would be appreciated!

Regards, Tony Brecko

[June7]

Are you using the Click event of the textbox?

Me!StartTime = Now()

[Missinglinq]

If you want to keep it as a simple as possible and you want the time/date to reflect when the Record is added, you could use the =Now in the Default Value Property of the Textbox' and the user wouldn't even have to click into the box!

Linq ;0)>

[tonybrecko]

If you want to keep it as a simple as possible and you want the time/date to reflect when the Record is added, you could use the =Now in the Default Value Property of the Textbox' and the user wouldn't even have to click into the box!

Linq ;0)>

Yeah, I tried that. The problem is that i want the user to alternate input between StartTime and EndTime. So the default value doesn't really apply.

[tonybrecko]

I am using the onClick property of the text box in the sub form. And it works fine when using the sub form direct, but when using the main form it throws an error.

I am not sure what you mean by:

Me!StartTime = Now()

[Dal Jeanis]

Remember, a subform is NOT a member of the Forms collection. It is more like a control on the form.

That's why this syntax works on the subform when it's a main form, but doesn't work as a subform:
Forms!frm_TimeLogSub![StartTime] = Now()

Use June7's code and it will work both ways. That's because, in code inside a control, Mrefers to the form or subform the control is on. Should work with a period instead of an exclamation mark, too.

But, if you are trying to capture the start time, I don't understand why the user would have to click anything at all.

[June7]

What do you mean by 'alternate input between StartTime and EndTime'? What does the date input represent? Start or End of what? Why would you want anything other than the current date/time, whether by DefaultValue or code?

Are you creating new record or updating a date field for existing records?

If you want to provide db with attempted code for analysis, follow instructions at bottom of my post.

[Dal Jeanis]

OKay, so you can use June7's suggestion in the same place as your code that throws an error -

Me!StartTime = Now()

Or you can let us walk you through your form design and see if we can give you a better architecture. Your choice.

[tonybrecko]

Thanks to all. Yes I got June7's code to work like a charm.

Just for clarification the reason that a default value wasn't appropriate is that in the sub form there is both a start and end time. I want the user to be able to click in the start time at the beginning of the job and then close the form and at the end of the job again open the form but this time click in the end time field.

I really do appreciate the quick help you all gave.