Date Stamp After Update

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!!
 
In the after update event of the 'archive due to' field put this code

[date archived] = Date()
 
Thanks dennis, that is perfect!

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

[date archived] = Date()

bamf said:
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!!
Click to expand...
Click to expand...
 
bamf said:
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!!
Click to expand...
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
 
Back
Top