S
SVE
Hi all,
I am sorry to be asking this, but I have tried various solutions from this
site and other sources, and can't get my cascades to work. I'm fairly new to
VBA and SQL so I'm probably just writing the code incorrectly. Here's the
data for the form and the relevent controls.
Form: Call Log
Combo box1: LotNumber (has columns: ID, LotNumber, SubdivisionName,
Homeowner; all from a table 'Lots')
Combo box2: ContactID (has columns: SubContactID, Expr1, CompanyName; from
table 'Subcontractor Contacts'; also, when I choose a name from this box, it
populates another text box on the form called 'CompanyName')
Combo box3: IssueID (has columns: LotsID, SubcontractorContact,
WorkToBePerformed, Status; from table 'Issues'; also has columns: LotNumber
from table 'Lots' and column CompanyName from table 'Subcontractor Contacts';
Status column has criteria: <>"Closed" Or <>"Resolved")
What I want to do is choose a LotNumber in Combo box1 (which will narrow the
list in combo box 3), then choose a contact in combo box2; when the combo box
2 choice populates the CompanyName text box, that data (Company Name) should
filter combo box 3 even further.
Can someone please help me out here? I appreciate any and all help. Thanks
in advance.
I am sorry to be asking this, but I have tried various solutions from this
site and other sources, and can't get my cascades to work. I'm fairly new to
VBA and SQL so I'm probably just writing the code incorrectly. Here's the
data for the form and the relevent controls.
Form: Call Log
Combo box1: LotNumber (has columns: ID, LotNumber, SubdivisionName,
Homeowner; all from a table 'Lots')
Combo box2: ContactID (has columns: SubContactID, Expr1, CompanyName; from
table 'Subcontractor Contacts'; also, when I choose a name from this box, it
populates another text box on the form called 'CompanyName')
Combo box3: IssueID (has columns: LotsID, SubcontractorContact,
WorkToBePerformed, Status; from table 'Issues'; also has columns: LotNumber
from table 'Lots' and column CompanyName from table 'Subcontractor Contacts';
Status column has criteria: <>"Closed" Or <>"Resolved")
What I want to do is choose a LotNumber in Combo box1 (which will narrow the
list in combo box 3), then choose a contact in combo box2; when the combo box
2 choice populates the CompanyName text box, that data (Company Name) should
filter combo box 3 even further.
Can someone please help me out here? I appreciate any and all help. Thanks
in advance.