Combo lookup box problem with deleted records

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.
 
M

Macy

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

MS Word normal.dot cannot be fixed 'text box' appears each time 4
Getting Radio Buttons to work, that are inserted via AutoText 0
Formatting combo box drop-down list 2
Filtering and Removing Filter based on a combo box 3
don't want combo box to be empty 2
Sort form records by field looked up in another table 1
Sub form problem displaying value of combo box 2
requery lookup information 2

Top