Minddumps
Registered User.
- Local time
- Today, 19:18
- Joined
- Jul 5, 2011
- Messages
- 73
[Solved] Subform won't load from combo box selection--need to load so can add record.
[Solved: Thank you to CJ London for his help ]
Hello everyone and HAPPY FRIDAY!!! I haven't found any solutions that work for me so I'm seeking help from you. Anything you can offer me is much appreciated
There are 2 issues I’m trying to figure out for an Access2007 form:
1) I should first state that I am working off of 3 tables:
a) Marketers
b) Companies that belong to those marketers
c) Points of Contacts (POC) for each Company
2) In my frmMain, I have 2 combo boxes. The first loads the second and the second loads a CompanyID text field (IDc) that the subform bases for which record info to pull. How do I get the CompanyID (and subform) fields to load blank upon form open and until the 2nd combo box selection is made?
3) A company that doesn’t have any POCs entered yet won’t load its CompanyID even though it DOES have an ID number. Well the Id not being changed doesn’t change the POC info either… I’m guessing it’s because there is no info to fill in the subform yet. However, I need to be able to still pull up the blank fields so I can ADD a POC. Can someone please review my form and vba code to see why a company with no POCs yet won’t load?
[Solved: Thank you to CJ London for his help ]
Hello everyone and HAPPY FRIDAY!!! I haven't found any solutions that work for me so I'm seeking help from you. Anything you can offer me is much appreciated
There are 2 issues I’m trying to figure out for an Access2007 form:
1) I should first state that I am working off of 3 tables:
a) Marketers
b) Companies that belong to those marketers
c) Points of Contacts (POC) for each Company
2) In my frmMain, I have 2 combo boxes. The first loads the second and the second loads a CompanyID text field (IDc) that the subform bases for which record info to pull. How do I get the CompanyID (and subform) fields to load blank upon form open and until the 2nd combo box selection is made?
3) A company that doesn’t have any POCs entered yet won’t load its CompanyID even though it DOES have an ID number. Well the Id not being changed doesn’t change the POC info either… I’m guessing it’s because there is no info to fill in the subform yet. However, I need to be able to still pull up the blank fields so I can ADD a POC. Can someone please review my form and vba code to see why a company with no POCs yet won’t load?
Attachments
Last edited: