Combo Box

Combo Box

Combo Boxes

Combo Boxes are the most fascinating and useful “Controls” you can have on your Form. They have Many uses. Combo Boxes can be manipulated in all sorts of ways without using VBA. Once you’ve mastered the combo-box, and once you have mastered Queries, the building of queries in the query builder grid, a Query you have designed to provide your Combo-Box with a unique set of Records, then it’s a short step to becoming a VBA programmer. One of the most powerful things you can do with VBA is control what your Combo Box does. You can add fantastic and clever features to your Form with minimal VBA, and minimal effort! It is a small stepping stone, on the way to becoming a VBA programmer. The first step, learn the inside outs of Combo Boxes. Learn how to make queries in the query builder grid, and then you will be ready! You will be chomping at the bit to take that Next step into VBA!

Combo Boxes - In the Beginning

The Most Basic Combo Box

Video 1 (4:45)

In this video I show the creation of a very simple combobox. The combobox is unbound and stores it’s values within itself in a “Value List”. I demonstrate creating a combo box both with and without the control wizard. I demonstrate enabling the ability for the user to add new values to the Combobox list. I demonstrate how to stop the user changing values. I demonstrate how you can allow the user to type “Free Text” – anything they like in the combobox.

Video 1 (4:45)

The Following links take you to key places in the video:-

00:30 select a control from the designer tab

00:33 add a combobox with wizard support

00:45 switch the wizard off

00:57 add a combo box without wizard support

01:15 using the wizard; type in the values you want

01:55 the combobox is “unbound”

02:25 allow free typing entries

02:45 set “Limit to List” to Yes

03:00 ask user if they want typed value saved to the list

03:17 shows the item added to the list

03:37 property sheet displaying the values in the “Value List”

03:47 set “Allow Value List Edits” to “NO”

04:12 the “Agile Programming Method”

… …

Get Info From a Combo-box

Get Info From a Combo-box

Video 2 (5:50)

This video shows how to display information from a Combo Box in a text box. Consider a combo box in which you select the customer’s name, then the “After Update Event” causes the address details for that customer to be displayed on the form in text boxes…

Video 2 (5:50)

… …

Form with Combo Box Lookup

Form with Combo Box Lookup

Video 3 (4:56)

Combo boxes are one of the most difficult things to understand. In this video I hope I make them a bit clearer.

Video 3 (4:56)

… …

Cascading Combo Box

Cascading Combo Box

Video 4 (10:19)

This video shows you how to change the Row Source of the “cascade” combo, with an SQL Statement and the after update event of the Selection combobox

Video 4 (10:19)

… …

Combobox - Change Query Criteria

Change Query Criteria with a Combobox

Video 5 (12:26) - 4-Min Excerpt

Demonstration of how to set up a Combo-box and a subform. This demonstration uses the older version of the Northwind Database. The Combo is Shown restricting the records displayed in the subform. This method utilises the Query that the subform is based on. The Selection in the Combo Box provides the Criteria for the Query.  This method requires the Subform/Subreport Control be refreshed, the method employed is demonstrated in the video.. Nifty Access is Here to  help Establish you as the “Go To” person in your organisation for database improvements! Nifty Access – will quickly elevate you to “Power User Level!”

Video 5 (12:26) - 4-Min Excerpt

More Info on th Northwind Sample dB:-

… …

Combobox - Displaying a Number?

Combobox - Displaying a Number?

Video 6 (7:17) - 5-Min Excerpt

Your combobox is displaying a number instead of text? In this video I demonstrate one way you can fix this problem…

Video 6 (7:17) - 5-Min Excerpt

Combobox - Displaying a Number?

… …

Combobox - Show Country & Region

Combobox - Country & Region

This DOWNLOAD example is in answer to a particular Question on Access World Forums (AWF) – The OP wanted to enter the name of a country into a text-box on an MS Access Form and then have a combo-box to display the continent/region? related to that selection. I suggested an alternative method, using a combo box to select only the Country and have the continent/region extracted from the ComboBox and displayed in a text box. I used a data-set I downloaded (Excel Format) from the internet to create the entries in the table for this MS Access demonstration from this URL here:- StatvisionThe information for the Microsoft Excel file was created from information provided by this website here:- gsociology.icaap.org You can download the MS Access example from the Sellfy website here:- Country / Region Combo Box Example — (99 Cents). You can get it for free by entering the Coupon Code:- “BuyTonyA_coffee”

… …

Leave a comment