Results 1 to 1 of 1
  1. #1
    Join Date
    Nov 2011
    Posts
    413

    Unanswered: Unbound Popup Form Not Updating

    I have a popup form that I use to enter data with and then have it update another field on another form using the OnClose Event.My code is not working.Popup from is named frmFEmpBonusDescription and form that ges the update afterwards is named FEmpBonus,it is a sub form on another form named Employees.The OnOpen event works fine and shows the correct data.?

    Private Sub Form_Close()
    On Error GoTo Err_Label21_Click
    Forms![FEmpBonus]![Description] = Forms![frmBonusNotes]![TxtDescription]
    TxtDescription.SelStart = Len(Description)
    DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

    Forms![FEmpBonus]![Description].SetFocus
    DoCmd****nCommand acCmdSaveRecord
    Forms!FEmpBonus.Dirty = False
    DoCmd.Close

    Exit_Label21_Click:

    Err_Label21_Click:
    Exit Sub
    End Sub
    Last edited by Burrina; 11-29-11 at 17:41. Reason: Make Clearer.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •