The following userform contains one combo box, with an identifying label. You want to populate the combo box using the list in A1:A6 (on a sheet named LookupLists, which isn’t shown in the figure).

I have a combobox that I want to populate with a list of vendors stored in another Access Database. This database contains roughly 1,300 different vendor records. All I'm interested is the names.I ...

Click the Combo Box icon, which looks like a drop-down menu. Click-and-drag the cursor to draw the shape and size of the drop-down menu. When you release the button, the Combo Box Wizard opens.

You can use XML to help you determine whether a user has made any changes to the data on one of your forms (if the form is "dirty"). This code checks for the standard TextBox, CheckBox, ComboBox, ...