access.course - Creating drop down fields

Hi James,

You can also achieve this in Excel but you need a bit of VBA code.

1) To create a drop down list, you must first draw a COMBO BOX from the TOOLBOX toolbar.
2) Switch on Properties to name it, e.g. cboList1
3) Once it's drawn, double click inside the COMBO BOX picture (it will then switch on VBA window)
4) Put in the code starting with combo box name, for example: cbolist1.additem "Apple"

The .additem code will add labels into the box.

Let me know if this is sufficient. There is another way for a dynamic list of labels, using FOR...NEXT loop

Hope this helps.

Regards,

Katie