This is probably simple - Value Not Being Saved

[crhodus]

I can't get my form to save a value that I pass into it. I have a form that promptsthe user to enter his/her name. After they enter in their name and press OK, the Log In screen is turned invisible and my company form is launched.

Whenever a new record is added to the company form or data is edited in the company form, I have code that is to pass the value from the "hidden" Log In form to the company form and save this value in the company form.

Everything in my code seems to be working except that the value that is passed is not being saved. I can see the value being passed into the company form when changes to a record are made, but this value is not being saved. Why won't the UserName value not save in my TEMP_USER field?

Can anyone tell me what I'm doing wrong?

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.LAST_UPDATED = Date
TEMP_USER = Forms!frmModifiedUser!UserName
Me.TEMP_USER = Forms!frmModifiedUser!UserName
End Sub

Thanks!

[This message has been edited by crhodus (edited 08-29-2001).]

[This message has been edited by crhodus (edited 08-29-2001).]

 

[crhodus]

My code seems to be working correctly. I didn't make any changes to it. I think it was just Access acting up.

If anyone know of a better way for me to do what I described above, I would be interested in knowing.

Thanks.