Date Stamp After Update

[Guest]

Hi,

I have a fairly simple table structure, one master table with a unque ID
field and all core data, with sub tables including additional data linked by
the ID field. I have forms to show each view and i need to be able to
archive pupils from each view. I have a 'Archive due to' list box field and
a 'date archived' field in the master table that show on each form. I would
like to be able to date stamp the 'date archived' field when a value is
selected in 'archive due to'.

I have played around with this and do not seem to be getting anywhere. Any
help would be great!!

 

[Guest]

In the after update event of the 'archive due to' field put this code

[date archived] = Date()

 

[Guest]

Thanks dennis, that is perfect!

In the after update event of the 'archive due to' field put this code

[date archived] = Date()

Hi,

I have a fairly simple table structure, one master table with a unque ID
field and all core data, with sub tables including additional data linked by
the ID field. I have forms to show each view and i need to be able to
archive pupils from each view. I have a 'Archive due to' list box field and
a 'date archived' field in the master table that show on each form. I would
like to be able to date stamp the 'date archived' field when a value is
selected in 'archive due to'.

I have played around with this and do not seem to be getting anywhere. Any
help would be great!!

 

[Keith]

Hi,

I have a fairly simple table structure, one master table with a unque ID
field and all core data, with sub tables including additional data linked
by
the ID field. I have forms to show each view and i need to be able to
archive pupils from each view. I have a 'Archive due to' list box field
and
a 'date archived' field in the master table that show on each form. I
would
like to be able to date stamp the 'date archived' field when a value is
selected in 'archive due to'.

I have played around with this and do not seem to be getting anywhere.
Any
help would be great!!

In the form's Before Update event use:

Me.txtMyTextBox = Now()

where txtMyTextBox is the name of the text box bound to your 'date archived'
field.

HTH - Keith.
www.keithwilby.com