If I've understood you correctly, you will need to "Refresh" the form after the first Combo Box has changed. This will ensure that the data you have just entered is stored in the table. Then you will need to "Requery" the second Combo Box to ensure that it has picked up the changes you have just made to your first Combo Box.