I have a subform for a Junction table, it links a SurveyID to a ProjectID.  The projectID comes from the ProjectTable. There is a combobox to select from a list of projectID's.  The Project table also has a name field for each project. Following Expert8 class, I built a Query that connects the Junctiontable to the Project Table. I changed the ControlSource of the junctionTable subform from the JunctionTable to the Query. I added a field for the name and it displays it just fine. However, now the combobox for the ProjectID wont let me change the projectID. It is a continuos form and I can add a new ProjectID but I cannot change the one that was originaly in there in the first row. In Expert 8 Richard says sometimes you cant update the info when you use a query like this. And I acutally really want this to be a Single Form so it will only have one ProjectID in there as the MAIN ProjectID. So what do I do? Thanks!