Solved A Main form does not display data when subform left blank

[OverSight]

I am having an issue where one of my main forms will not display or populate data until a subform is populated.

This is a Vendor database with contact information. The main form frmVendorsDetails contains all contact information of the vendor. within this form is a subform frmVendorPOCs subform that contains the specific point of contact details for the vendor. If I populate both the main form and the subform all works well, but if I only populate the main form and I do not enter anything in the subform, the Main form will not display any information.

I do have a one-to-many relationship with tblVendors and tblVendorPOCs.

When I save the record, all of the info from the main form populates tblVendors but if the subform isn't filled out it there is never a record created in tblVendorPOCs and seems to cause this issue.

I would like the main form to display even if there is no point of contact filled out in the subform as some of the data will be populated in the future or the vendor does not have a specific point of contact.

 

[arnelgp]

are you using Query with Inner Join?
if so, use Left join:

select tblVendors.*, tblVendorPOC From tblVendors Left Join tblVendorPOC
On tblVendor.[Vendor Number] = tblVendorPOC.[Vendor Number]

 

[OverSight]

are you using Query with Inner Join?
if so, use Left join:

select tblVendors.*, tblVendorPOC From tblVendors Left Join tblVendorPOC
On tblVendor.[Vendor Number] = tblVendorPOC.[Vendor Number]

Hey there, Yes you are right it was showing Inner Join! Thank you very much for this! I think this is now working!