Form_Update event (Before or After)

Hi

I used a date field that should automatically update as of NOW() when update/change any objects on the form. But it is not working as I expect, when I open the form it update the date field as of NOW() even if I don't do anything on the form objects. I used Form_BeforeUpdate event for the form. I try to get Form_AfterUpdate event which give me message "you entered an expression that has an invalid reference to the property".

I linked references :
1. VB for Application
2. MS Access 11.0 object library
3. MS DAO 3.6 object library
4. MS Activex Data Object 2.8 library
5. OLE Automation

What should I do! Should I need any more reference link for this purpose! I need this updated date field to track the record status.


I appreciate your kind cooperation in advance.

regards

Habib

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com/default.aspx?ref=ng

Mohammad,

I put it here...

Private Sub Form_Dirty(Cancel As Integer)
Me.DateFieldYouWantModified = Now()
End Sub

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

Mohammad HABIB wrote in message
...
Hi

I used a date field that should automatically update as of NOW() when
update/change any objects on the form. But it is not working as I expect,
when I open the form it update the date field as of NOW() even if I don't
do anything on the form objects. I used Form_BeforeUpdate event for the
form. I try to get Form_AfterUpdate event which give me message "you
entered an expression that has an invalid reference to the property".

I linked references :
1. VB for Application
2. MS Access 11.0 object library
3. MS DAO 3.6 object library
4. MS Activex Data Object 2.8 library
5. OLE Automation

What should I do! Should I need any more reference link for this purpose!
I need this updated date field to track the record status.


I appreciate your kind cooperation in advance.

regards

Habib

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com/default.aspx?ref=ng

On Wed, 07 Jan 2009 19:25:20 -0800, Mohammad HABIB wrote:

This is most likely not a References problem.

You say that the date field updates when you open the form. I am
assuming you don't want that. You need to find the code that makes
that happen. If I had to debug that I would look in the Form_Open,
Form_Load, and Form_Current event. Also check the control properties:
you could have an expression in the date_control.ControlSource.

To check if the Form_BeforeUpdate code works, set a breakpoint and
step through.

-Tom.
Microsoft Access MVP



Hi

I used a date field that should automatically update as of NOW() when update/change any objects on the form.
But it is not working as I expect, when I open the form it update the date field as of NOW() even if I don't do anything on the form objects.
I used Form_BeforeUpdate event for the form. I try to get Form_AfterUpdate event which give me message
"you entered an expression that has an invalid reference to the property".

I linked references :
1. VB for Application
2. MS Access 11.0 object library
3. MS DAO 3.6 object library
4. MS Activex Data Object 2.8 library
5. OLE Automation

What should I do! Should I need any more reference link for this purpose! I need this updated date field to track the record status.


I appreciate your kind cooperation in advance.

regards

Habib

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com/default.aspx?ref=ng

On Wed, 07 Jan 2009 19:25:20 -0800, Mohammad HABIB wrote:

Hi

I used a date field that should automatically update as of NOW() when
update/change any objects on the form. But it is not working as I
expect, when I open the form it update the date field as of NOW() even
if I don't do anything on the form objects. I used Form_BeforeUpdate
event for the form. I try to get Form_AfterUpdate event which give me
message "you entered an expression that has an invalid reference to the
property".

I linked references :
1. VB for Application
2. MS Access 11.0 object library
3. MS DAO 3.6 object library
4. MS Activex Data Object 2.8 library 5. OLE Automation

What should I do! Should I need any more reference link for this
purpose! I need this updated date field to track the record status.


I appreciate your kind cooperation in advance.

BeforeUpdate is the best event for this. Are you sure you didn't also
set a DefaultValue for that field in the table or for the control on the
form? In that case the BeforeUpdate code will still work. It will just
replace the default value when you save.


--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com