Update Date

[matthew.newsome]

I have 4 fields on a form, they are simple drop downs, which can be
changed throughout the life of a record.

I have a date field that users change when they changeone of the four
drop downs, sort of a last update date.

Can I automate the date field to change to to whatever the date is
when a drop down is changed.

Thanks

Matt

[Keith Wilby]

<ma*************@npower.comwrote in message
news:11*********************@v33g2000cwv.googlegro ups.com...

>I have 4 fields on a form, they are simple drop downs, which can be
changed throughout the life of a record.

I have a date field that users change when they changeone of the four
drop downs, sort of a last update date.

Can I automate the date field to change to to whatever the date is
when a drop down is changed.

Thanks

Matt

Yes, put this code in your combo box's after update event:

Me.txtMyTextBox = Date

HTH - Keith.
www.keithwilby.com

[matthew.newsome]

Hi Keith, I get an error message saying MS Access cant find macro ME.
am i been thick.

I have used:-

Me.txtText543 = Date

Thanks

Matt

[Keith Wilby]

<ma*************@npower.comwrote in message
news:11**********************@l53g2000cwa.googlegr oups.com...

Hi Keith, I get an error message saying MS Access cant find macro ME.
am i been thick.

I have used:-

Me.txtText543 = Date

Thanks

Matt

You need to add the code to a class module - open your form in design view.
Select your combo box, then on the properties box select the "Event" tab.
In the After update event, select "[Event Procedure]", then click just to
the right of the white box area. This should open the class module and
place the cursor where the code needs to go.

"Me" is a keyword and refers to the current class module. Your text box is
an object associated with the class module, so when you type "Me." (note the
full stop/period) you should get an "intellisense" list containing the name
of your text box. Select the name from the list and that should do the
trick.

HTH - Keith.
www.keithwilby.com

[matthew.newsome]

On 20 Feb, 16:04, "Keith Wilby" <[e-mail]:

<[e-mail] in message

news:11**********************@l53g2000cwa.googlegr oups.com...

Hi Keith, I get an error message saying MS Access cant find macro ME.
am i been thick.

I have used:-

Me.txtText543 = Date

Thanks

Matt

You need to add the code to a class module - open your form in design view.
Select your combo box, then on the properties box select the "Event" tab.
In the After update event, select "[Event Procedure]", then click just to
the right of the white box area. This should open the class module and
place the cursor where the code needs to go.

"Me" is a keyword and refers to the current class module. Your text box is
an object associated with the class module, so when you type "Me." (note the
full stop/period) you should get an "intellisense" list containing the name
of your text box. Select the name from the list and that should do the
trick.

HTH - Keith.www.keithwilby.com

Keith, thats great thanks for your help, if you do read this do you
know of a good Access book I could buy to help me further, about this
level (little bit of VB)

Thanks again

Matt

[Keith Wilby]

<ma*************@npower.comwrote in message
news:11*********************@h3g2000cwc.googlegrou ps.com...

>
Keith, thats great thanks for your help, if you do read this do you
know of a good Access book I could buy to help me further, about this
level (little bit of VB)

Hi Matt, try this or just search Amazon's book section for "microsoft
access":

http://www.amazon.co.uk/Access-VBA-P...e=UTF8&s=books

Keith.