Ok, Ive been looking at the northwinds database and im trying to figure out how to update a subform based on a combo box such as how its done on the home page. First, i have two tables: Programs and Devices. There is a limited number of programs but there are multiple devices for each program(see pictures). I also have a form with a combo box whose values are based on the programs table. It is set to requery the page afterupdate. My question is what steps would i have to take in order to sync the subform so that when the program is selected from the combo box, it would show only the devices for that program. Thanks in advance. sorry if this is a dumb question. I have no experience with access (been using excel for years) and my job decided they wanted to build a database.