First, are you sure the drop-down lists have a row source that is a query or
Open the form in design view and click on the drop-down list and get its
properties. If the row source type is Value List then the list is typed in
the row source property. (generally a bad design feature - especially if
things can change.
If you mean you cannot Access the design view of forms, etc. Are you sure
that this is not an .mde or .ade database? If the database has been made
into an mde or ade you cannot change the forms or reports or vba code. You
need the original mdb or adb to make changes.
Data in Tables can be changed.
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
Post by kwgwynn
I have some Access experience -- creating some simple databases -- and now I
am at a new job where there is an Access database with no "access" to the
author. The database uses forms for data entry (something I've never
programed; don't know if that's an issue here). This is a fairly simple
What I'm trying to do is this: there are multiple drop-down lists that
provide choices to idenify a member's interests. However, the choices are out
of date. I want to go in and update these lists. But I can't find them. Where
are these lists? Best I've found are the table descriptions by view the
relationships, and that isn't at all helpful.
Is this going to be a permission thing? Any assistance is greatly appreciate.