Drop down question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with a drop down list to find a file. If I delete a file the
drop down list shows "Deleted" and if I add a file, the add does not show up
unless I close the form and reopen it. I am sure there is a way to update the
drop down list but I do not know how. Help would be appreciate.
 
Hi Nick,

what is the SQL of your Delete query, and are you running it with code, or
just running the query from the DB window?

If you were doing this from your form on which the combobox resides, you'd
generally use a command button. The basic structure of the code would be:

Private Sub cmdDeleteButton_Click()
CurrentDb.Execute "DELETE * FROM SomeTable", dbFailOnError
Me.MyCombo.Requery
End Sub

Brian
 
Back
Top