TESTDATABASE.zipTESTDATABASE.zipI am attempting to create a Main Form with Subforms. The main form is created from a simple table (Project Number) containing ContractID, Project Number, etc. The subform (Contracts) contains the ContractID as well as several other fields I want displayed. (Relationship is ContractID) I am looking to display all the CONTRACTS that are associated with each of the PROJECT NUMBERS. My combo box is connected to the PROJECT NUMBERS and as you can see from the screen shot, there are several CONTRACTS associated with each PROJECT NUMBER. However, they do not display. Only the first record from the CONTRACT subform shows. They cannot be selected from the combo box, but I can tab through and see them.
I have tried so many things and redone it several times, only to get the same result. Help, I'm disparate.Attachment 38496Attachment 38497