how to edit cell that has the wrong drop down options

G

Guest

I have a file that has some old drop down menus. I no longer want those drop
down values. I want to either take away the options or change the choices.
What can I do?
 
P

Pat Hartman\(MVP\)

It depends on the RowSource of the combo. If the RowSource type is a Value
List, you would change the values in the combo itself. If the RowSource
type is table/query, you would need to change the values in the base table.

Before you make any changes to the list values, be sure not to change or
delete a value that is referenced by some record.
 

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

Restrict Choice in Shared WB (drop down alternative)? 0
Can't see drop-down menus? 6
drop down lists and reports/exports 3
Form and lost drop down list 1
Drop Downs 1
Drop Down in Form View 3
filtering one drop down to another drop down 5
Display drop-down on form to allow user input 2

Top