Subform does not show up on main form
Posted: Mon May 05, 2014 5:21 am
Hi,
I am trying to get a subform to show up on a main form. I have looked at many videos and read the wiki on subforms multiple times but I can't get it to work. I also did some searches on 'subform' in the forum but there were over 300 hits and the ones I looked at didn't help me resolve this problem.
The main edit form displays information about a vendor. I want a subform that shows all of the projects (from the projects table) that this vendor has been involved in. Here is the main vendor form: I want the 'vendor' name field (vend_company) to be the common field between the main form and the subform. When I click on the 'Vendor' label, I get the following for the 'All' definition: and here is the definition for the subform: Here is the general defintion for the 'vendor_projects' form which is the subform I want displayed on the 'vendor' form: and the browse definition for the vendor_projects form. I realize that there may be some problems with the SQL and some of the definitions but I can't even get a blank subform to show on the main form. I tried to use the subform wizard but it created the subform in a separate tab for the vendor form and I couldn't figure out how to move it to the main form. Some of the subform examples in the forum use a 'lookup' field on the main form but I didn't see a reason for a 'lookup' field for the vendor name since I either selected the vendor from the browse screen or created a new vendor using 'Add Record'.
As before, I would appreciate your pointing me in the right direction.
Thanks,
John
I am trying to get a subform to show up on a main form. I have looked at many videos and read the wiki on subforms multiple times but I can't get it to work. I also did some searches on 'subform' in the forum but there were over 300 hits and the ones I looked at didn't help me resolve this problem.
The main edit form displays information about a vendor. I want a subform that shows all of the projects (from the projects table) that this vendor has been involved in. Here is the main vendor form: I want the 'vendor' name field (vend_company) to be the common field between the main form and the subform. When I click on the 'Vendor' label, I get the following for the 'All' definition: and here is the definition for the subform: Here is the general defintion for the 'vendor_projects' form which is the subform I want displayed on the 'vendor' form: and the browse definition for the vendor_projects form. I realize that there may be some problems with the SQL and some of the definitions but I can't even get a blank subform to show on the main form. I tried to use the subform wizard but it created the subform in a separate tab for the vendor form and I couldn't figure out how to move it to the main form. Some of the subform examples in the forum use a 'lookup' field on the main form but I didn't see a reason for a 'lookup' field for the vendor name since I either selected the vendor from the browse screen or created a new vendor using 'Add Record'.
As before, I would appreciate your pointing me in the right direction.
Thanks,
John