You have a calculation as the ControlSource of your control in Form2. You should bind the control to the field you want to update (the FK field). The Open event is too early in the process to reference a control on a form; you need to use the OnLoad event. Then you could use the OpenArgs or the Forms collection to set the value of the Form2Control and it will save. Me.SID = Forms!Form1!SID
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 Pro - acXP, ac07, ac10, ac13
If your issue is resolved...go ahead and use the Thread Tools at the top of the thread and mark the thread as Solved!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"