Sean_Sean
01-27-2002, 02:18 AM
You replied to my message the other day about linking the combo-boxes, but after following your instructions:
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
This final bit doesn't seem to work, i get an error telling me that "The command or action 'Refresh' isn't avalible now"
Please help, much appreciated, thanks
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
This final bit doesn't seem to work, i get an error telling me that "The command or action 'Refresh' isn't avalible now"
Please help, much appreciated, thanks