I am having a program with my attachments subform not showing fields in the mainform I have created.
My mainform is developed from a query that bridges "ProjectNumbers" to "ContractID". Each subform is created from a query that does the same as the main form. I have a search query field where Project number can be selected and I now have that working and syncronized.
My problem is with the attachments subform. When I go into the single subform and design it for datasheet viewing (as one project number may return several contacts, thus several rows of attachments), I can see it clearly. However, when I open the main form, the ProjectNumber and ContractID show, but the fields where the attachment should show, there is nothing.
Also when I view as a single or continuous form, there is nothing for attachments either. Not in the subform itself or when it shows up on the mainform.
Database is currently under 2gig, so it is not the file size. Although I will move to detaching the file and using a url.
I cannot upload the database due to proprietary information, but have attached some screenshots and can answer all questions.
My mainform is developed from a query that bridges "ProjectNumbers" to "ContractID". Each subform is created from a query that does the same as the main form. I have a search query field where Project number can be selected and I now have that working and syncronized.
My problem is with the attachments subform. When I go into the single subform and design it for datasheet viewing (as one project number may return several contacts, thus several rows of attachments), I can see it clearly. However, when I open the main form, the ProjectNumber and ContractID show, but the fields where the attachment should show, there is nothing.
Also when I view as a single or continuous form, there is nothing for attachments either. Not in the subform itself or when it shows up on the mainform.
Database is currently under 2gig, so it is not the file size. Although I will move to detaching the file and using a url.
I cannot upload the database due to proprietary information, but have attached some screenshots and can answer all questions.