Need to eliminate deleted items from a drop down list

G

Guest

I have a drop down list in one form based on a query from a table. In
another form I give the user the ability to delete records from this table,
followed by a requery of the drop down list in code. When the user returns
to the first form and drops the list down the deleted row still appears as
"#deleted". Is there a way to prevent the deleted records from appearing
in the list?

Bill
 

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

Excel Excel: How do I put a formula in a drop down list 11
Drop down list inside a query 6
Drop-down list and error message 1
drop down menu in query 1
Drop down list search 2
Filtered drop down list 2
Excluding items from a table so user cannot see or select them 3
Drop down list from index/match formula 1

Top