Microsoft Access Database Tutorial: Access Combo Boxes Working Dynamically

Microsoft Access Database Tutorial: Access Combo Boxes Working Dynamically

Take a look at this 5 minute video about Access combo boxes in a form which is dynamically linked together so when a value is selected from the first control the second combo box dynamically filters as a sub list.

Microsoft Access Database Tutorial: Access Combo Boxes Working Dynamically

The narrator is correct on several fronts when he mentions that Access combo boxes in a form is a highly sought after requirement and is not a standard feature to Microsoft Access!

You can use either VBA code (as demonstrated) or use an Access macro using the ‘Requery’ action command. Either way, there is little programming to cover here.

access combo boxesAlso, you will need to refine it further which could include removing the current value from the second combo box each time a new item is selected from the first (as mentioned) making your Access combo boxes really friendly.

Take the time to learn about good form designs and to help you along, I have an eBook on just the subject: How to build Access forms.

This entry was posted in Forms, Macros, MS Access, VBA and tagged , , , , . Bookmark the permalink.

3 Responses to Microsoft Access Database Tutorial: Access Combo Boxes Working Dynamically

  1. Ben says:

    In the combobox, you can refer to different columns using the [Column(0)] property where 0=the first column and increments for each column of the data source of the combo box control.
    So you can populate another control like a Textbox to =[ComboBox].[Column(2)] if the third column is required.

  2. Sue Cox says:

    I think your tutorials are great but I am hopeful to find one more thing. on a form I have a combo box to identify if vehicle is leased or owned, when I add a new vehicle I select from the combo box if the vehicle is leased I then want the account box below this combo to populate with either of the two account codes any help I have tried the query option I have tried expression I have tried builder :( oh woh is me any help would be great full

  3. Ben says:

    In the query of the second combo box control, the refernce in the criteria has the following syntax: [Forms]![name of form]![name of first combo box]

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>