Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jul 2005
    North Carolina, USA
    Thanked 0 Times in 0 Posts

    Updating an unbound list after deleting data (2003)

    Hi, I am having some problem updating an unbound combo box that display the list of personnel from a query. If I delete a personnel record and then I click on the combo box to get someone else, inside the list appears " #Deleted " . I tried to use the Me.fldPersonnel.Requery in the After Update event. The fldPersonnel is the name for the combo box. The row source is a qryPersonnel that have all the names. Any help is appreciated.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Updating an unbound list after deleting data (2003)

    Deleting a record doesn't cause the After Update event to fire. I'd add code to requery the combo box in the On Current event of the form - after you delete a record, the form moves to another record, so the On Current event occurs.

Posting Permissions

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