Hi - I accidentally posted this in the wrong forum so here it is again.

I cannot requery a combobox after new records are added to the table it is getting its info from.  I trigger it with an On Close Event for the form to add records to the table its referencing.  I have done this with other comboboxes and its worked fine with the code:

Forms!ArchaeologyDatabaseF!ProctPinsSUBF.Form!AddProjectCOMBO.Requery

But when I try it with another combo box on a different subform its not working. Here is the code:

Forms!ArchaeologyDatabaseF!LOCHwyStateRouteSUBF!StateRouteCOMBO.Requery

There is a difference with the control sources.  The combobox where it is working is referencing a Junction Table directly as the control source and the additional records table in the Row Source.  The one thats not working is referencing a QUERY in both the control and the row sources, which are querying a Junction Table and the Table the additional records to list in the combo box are coming from. Any suggestions?