form locks when afterupdate propert is used...

[burgesse]

I am updating a date, and userid field with "afterupdate" property set on the form property. When I do this, the entire form locks, except, the record that was updated. I can't even go into design view.

What am I doing wrong,

Thanks

 

[LittleSmudge]

It sounds like you are saying to the system:-
I'm moving off this record
Save the data from the form to the record in the table
Now you've done that change the date and userId fields on the form ( Between undating the record and actually getting to the new record )

No wonder it gets confused.

If you want to change the Data and UserId in the record you are leaving then use BEFOREUPdate

If you want to change the Data and UserId in the record you are going to then use OnCurrent


'ope-that-'elps.

G LS