S
Scott Burke
I have two forms.
1) Login form
2) Sales Method form
When you "Login" a global var "G_USERID" is filled in with the user name.
When you make a chnage in the "Sales Method" form the following happens.
Me.[changeby] = G_USERID
Me.[changetime] = date
This happens in "On Dirty" plus every buttom and field on the form.
(I did not write the code)
All of this is simple and it works 97% of the time.
Problem:
3% of the time [changeby] is updated to " ".
[changetime] is wrong. Sometimes it is NOT updated. Sometimes it is off
by days.
Any ideals how G_USERID could lose it's value? what is up with DATE?
Scott Burke
1) Login form
2) Sales Method form
When you "Login" a global var "G_USERID" is filled in with the user name.
When you make a chnage in the "Sales Method" form the following happens.
Me.[changeby] = G_USERID
Me.[changetime] = date
This happens in "On Dirty" plus every buttom and field on the form.
(I did not write the code)
All of this is simple and it works 97% of the time.
Problem:
3% of the time [changeby] is updated to " ".
[changetime] is wrong. Sometimes it is NOT updated. Sometimes it is off
by days.
Any ideals how G_USERID could lose it's value? what is up with DATE?
Scott Burke