Re: [MS_AccessPros] How to add timestamp properly when adding and/or updating a form

Thanks John for your fast answer!

However, now I think I have found what causes me the confusion!

I have a form that I use to register new companies in my address table.
On this form I also have a button on which I click to open another form in which I register a contact person of this company.
The underlying tables are connected in a one-to-many relation meaning I can have several contact persons related to one and the same company.
The primary key of the address table is called Adressnr, and it appears as secondary key in the contact person table.
Now, among the fields that I present on the contact person form is also the Adressnr.
This field I want to have automatically filled in by Access, when I click the button to open the contact person form to enter a new contact person. To accomplish this, I have added the following piece of VBA code on the Event property "Private Sub Form_Current()"

'If IsLoaded("Adresstable") Then
Me!Adressnr = Forms!Adresstable!Adressnr
End If

This piece of code works fine for me, but it seems as if its very presence prevents the 'Timestamp = Now' to be processed as I want.
What shall I do to solve this problem?

Moreover, I have been using the event property 'On Change' so far to get Timestamp = Now.
Is that ok instead of 'After Update, as you suggested?

Regards
Dennis Davidsson

16 okt 2011 kl. 12:27 skrev John Viescas:

> Dennis-
>
> After Update is all you need. When you change and save a row, After Update
> fires. When you create a new row, After Update fires followed by After Insert.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Dennis Davidsson
> Sent: Sunday, October 16, 2011 12:13 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] How to add timestamp properly when adding and/or
> updating a form
>
> Hello,
>
> I have a table in which I have included a timestamp column in order to keep
> track of every time I add a new record or update an existing record.
> How shall I specify the Event properties for the form that I use to handle my
> table?
> I know that I shall add a Visual Basic line like 'Timestamp = NOW'.
> But to which of all the possible Event properties shall I add this line?
> Shall I add it to all the following:
> After Insert
> After Update
> On Change
> Or is there even more properties to consider?
>
> I have tried some of these examples, but I am confused by the behavior of
> Access. I cannot quite figure out the logic behind.
>
> Regards
> Dennis Davidsson
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>

[Non-text portions of this message have been removed]

------------------------------------

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@yahoogroups.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:
http://docs.yahoo.com/info/terms/