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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need combo box to refresh when moving to new record 2017 1
Filtering and Removing Filter based on a combo box 4
requery lookup information 2
delete records based on a combo box 3
Problem after canceling a delete 4
Combo Box Choose Record Problem 4
Help with using command button to delete a record from a table 3
Combo box value disappears 5

Back
Top