Updating data in exsisting drop down on form

[sarahchadwick74]

Hello there,
My apologies for my total ignorance with access. I have inherited an established database from a former colleague and have been asked to change the data in the form/table including drop down selections to reflect managerial changes.
Could I please ask for advice on how to do this? I don't need to change data type, just the names and names on subgroups. (I.e. in a "directorate" table, the directorates have changed names, and also the group's under those directorates in the drop-down menu).

Many many thanks from a total access novice.[emoji4]

[Missinglinq]

In Form Design View, with the Combobox (what you're calling a 'dropdown') selected, go to Properties - Data; what do you see in the Row Source Type property box? This will usually be Table/Query or Value List.

Linq ;0)>

[sarahchadwick74]

Thank you so much for taking time to reply to my naive questions! Unfortunately I have left work so I don't have the database open. I realise now it wasn't a good day for me to post a query-many apologies. I will have a look at this first thing on Monday. I really do appreciate you taking the time to help.

[Missinglinq]

No problem! Let us know after you have a look at it; how you need to do this depends on how it was originally set up.

Linq ;0)>

[sarahchadwick74]

Thank you I will.😊

[Missinglinq]

We'll be here!

BTW, Welcome to the Access Forums!

Linq ;0)>

[sarahchadwick74]

Hello...it said table/ query?? Thank you!

[sarahchadwick74]

Hi again, I have managed to alter the data (I kind of started again) but iam having trouble with my combo box. I want my specialities combo box to be based on the selection made in the first combo box "directorates" but at the moment it brings up everything? Is there a way I can limit what appears?

[sarahchadwick74]

This is my first combo box drop down......

[sarahchadwick74]

This is my second one..........

[Missinglinq]

The concept is called "cascading comboboxes" although the exact same thing applies to Listboxes with the MultiSelect Property set to None, and the code is interchangeable. Here are a couple of links with examples:

Cascading List for Access Forms

Cascading Combo/List Boxes

If you Google the term "Cascading Comboboxes" along with "MS Access" you'll probably get a gazillion hits!

Linq ;0)>

[sarahchadwick74]

Thank you so much again! If I could be bold to ask another daft question? Once this is set up and we are using the database, can I change data in these dropdowns? We are hoping the specializes don't change their directorates again but iam nervous of having to change field options if they do. It's taken me all day today to sort out the database to the point I've got it. Now iam nervous of working with it! 😖