Setting up Combobox on an Access Form in Design View ~ DataPig
This video shows how a combobox wizard option is displayed. The video demonstrates a non-wizard set up of a combobox. It also shows how the RowSource - data for the combobox - can be tested as a query before saving the design. In the example, the query design has to be adjusted to limit the Region choices being presented to the user.
Uses a Totals query to GroupBy in the RowSource of a combobox to eliminate duplicates. While this is an example how to show a list for a combobox, the data isn't normalized. That's okay to begin with. Later on, you'll want to store a foreign key (FK).
This video has been resurrected from an older Access tutorial series by DataPigTechnologies. Even though Access looks different now, the concepts and functionality persist. Thanks to owner, Mike Alexander, for making these videos available for presentation once again. Thanks also to Jack Drawbridge and John Clark for helping get these valuable lessons back online.