Use a command button to set a value in a record

[Abugilda0]

Hi,
I would like to use a command button to set current time in the selected text box in a form
Moreover, when I move to the next field i would like the previous value to be stored in the record (saved)


Thanks in advance

[Bob Fitz]

Perhaps:
Me.[TextBoxName] = Time()
in the On Click event of the button
And
If Me.Dirty Then Me.Dirty = False
in the Got Focus event of the "next field" textbox.

[Abugilda0]

Hi,
Probably did something wrong

[Bob Fitz]

Hi,
Probably did something wrong

Ah...but you're not telling us what you did do.

[Abugilda0]

Thanks Bob,
I have copied the syntax you gave me to the on click event of the button (Changed the name to the field in my table)
I get an error massage that it doesn't recognize what is Me (It want to run a macro or provide a macro name)

[Bob Fitz]

Have you just pasted it onto the space on the Property Sheet?
It needs to be in the form's code module.

[Bob Fitz]

Further to my last post I have attached an example database.

[Welshgasman]

Thanks Bob,
I have copied the syntax you gave me to the on click event of the button (Changed the name to the field in my table)
I get an error massage that it doesn't recognize what is Me (It want to run a macro or provide a macro name)

Most developers stay away from macroes, as they are limited compared to VBA.
I have only used them for batch processes and learnt VBA (as you should )

In Access 2007 you would use

[Abugilda0]

Thanks Bob so much
You probably figured that I'm still have large gaps of knowledge
I followed your instructions and even used your DB example
Still I'm getting this:
Microsoft Access cannot find the object Me
If 'Me' is a new Macro group, make sure you have saved it and that you have typed its name correctly
What can it be please

[Bob Fitz]

Thanks Bob so much
You probably figured that I'm still have large gaps of knowledge
I followed your instructions and even used your DB example
Still I'm getting this:
Microsoft Access cannot find the object Me
If 'Me' is a new Macro group, make sure you have saved it and that you have typed its name correctly
What can it be please

This sounds to me as though you are trying to use a macro in some way.
Like many others here I have little to do with macros, preferring the use of vba code.
Post a copy of your db so that we can determine what is wrong.

[Abugilda0]

Thanks so much
I have attached the DB

[Bob Fitz]

As far as I can see, your only problem is that in the property sheet for the button's On Click event you have:

Me.[Text16] = Time()

but you should have:

[Event Procedure]

as you have in the Got Focus event of the textbox named txtTimeEnd.
You already have the correct code in the form's code module for each of the afore mentioned events.