What do the different RowSourceTypes for list and combo boxes mean?
There are three possible values (‘Table/Query’. ‘Value List’, ‘Field List’) that can be used for this property. The document linked here gives an overview. The document here is from MS Access 2007 Help and gives some more detailed information. The database attached here shows how to use these properties with some VBA code. See Access FAQ #4, the Multi-purpose query database, for a further example.