Combo lookup box problem with deleted records

  • Thread starter Thread starter chris
  • Start date Start date
C

chris

Add Code after the delete action

mycombobox.requery

-----Original Message-----
I have a combo list box set up in my header that I look
Click to expand...
up records and then display on my form. I also have a
Delete Command button set up. My problem is if I delete
the record it then shows in the combo box as #DELETED. If
I click on it I get a run time error (data type mismatch
because it says deleted). How can I make my VBA code
either not try to look up the deleted record or make the
combo box not show the deleted record so it cannot be
selected.
 
Chris thank you so much! It's always a really easy process that we over complicate
That works great!
 
Back
Top