You can.
Right click on the second combo. Choose properties, then data. Goto the RowSource and hit the build button next to it. Start the query builder. On the grid make sure you put the fields you want to show. The first one should be the field you want to link the combo to the first one. In the criteria line for this field, put:
=Forms!frmFormName!FirstComboBoxName
Then, on the AfterUpdate event of your first combo, choose code builder and put this:
DoCmd.RunCommand acCmdRefresh
If you have difficulties, let me know and I will send you a demo.