RE: [MS_AccessPros] Last Updated - My error

 

Thanks Duane,

That worked. I can see the logic now!!! After the update the record is not dirty!

Cheers,

Robin


At 2/06/2016 09:28 PM, you wrote:

 

Robin,

Try the BeforeUpdate rather than the AfterUpdate.

Regards,
Duane Hookom, MVP
MS Access

> To: MS_Access_Professionals@yahoogroups.com
> From: MS_Access_Professionals@yahoogroups.com
> Date: Thu, 2 Jun 2016 10:20:57 +1000
> Subject: [MS_AccessPros] Last Updated - My error
>
>
> I am a modest Access user. As a result I have little experience.
>
> I have a form with a "Last Upated" field, [Lastupdated] and I need to
> update that field whhenever I make a change to the data.
>
> I have used this code in the 'After Update' property:
>
> = If Me.Dirty Then
> Me![LastUpdated]=Date()
> End If
>
> And I get an error message .
>
> I have also tried an eveny:
>
>
> Private Sub Form_AfterUpdate()
>
> If Me.Dirty Then
> Me![LastUpdated] = Date()
> End If
>
> End Sub
>
> which fails.
>
> Your help will be appreciated.
>
> Regards,
>
> Robin Chapple
>
>
>
> ------------------------------------
> Posted by: Robin Chapple <robinski@westnet.com.au>
> ------------------------------------
>
>
> ------------------------------------
>
> Yahoo Groups Links
>
> <*> To visit your group on the web, go to:
> http://groups.yahoo.com/group/MS_Access_Professionals/
>
> <*> Your email settings:
> Individual Email | Traditional
>
> <*> To change settings online go to:
> http://groups.yahoo.com/group/MS_Access_Professionals/join
> (Yahoo! ID required)
>
> <*> To change settings via email:
> MS_Access_Professionals-digest@yahoogroup s.com
> MS_Access_Professionals-fullfeatured@yahoogroups.com
>
> <*> To unsubscribe from this group, send an email to:
> MS_Access_Professionals-unsubscribe@yahoogroups.com
>
> <*> Your use of Yahoo Groups is subject to:
> https://info.yahoo.com/legal/us/yahoo/utos/terms/
>

__._,_.___

---

Posted by: Robin Chapple <robinski@westnet.com.au>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (3)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___