puppygirl3939
Technical User
I have 4 tables tblLead, tblReferral, tblCountySent and lstCounty. One Referral can be sent to one or up to 67 counties.
Lead Table - LeadID,LeadDate,Source,Company Address
Referral Table - LeadID,ReferralID,DateSent,Statewide
CountySent - CtySentID,LeadID,ReferralID,CountyID
County - CountyID,CountyName (List Table that contains all 67 counties in my state)
The Main Form is a Tab Form. Tab1 has the fields from tblLead, Tab2 has the fields from tblReferral and a Subform in a datasheet format with the fields of the tblCountySent.
When the user clicks on the Statewide Checkbox in Tab2 which is a field from tblReferral I want the system to add all 67 counties in the CountySent Table and update the CountySent Subform. If they click on it again it must delete all 67 counties from the CountySent Table.
It's basically a ON/OFF switch. Any ideas?
Lead Table - LeadID,LeadDate,Source,Company Address
Referral Table - LeadID,ReferralID,DateSent,Statewide
CountySent - CtySentID,LeadID,ReferralID,CountyID
County - CountyID,CountyName (List Table that contains all 67 counties in my state)
The Main Form is a Tab Form. Tab1 has the fields from tblLead, Tab2 has the fields from tblReferral and a Subform in a datasheet format with the fields of the tblCountySent.
When the user clicks on the Statewide Checkbox in Tab2 which is a field from tblReferral I want the system to add all 67 counties in the CountySent Table and update the CountySent Subform. If they click on it again it must delete all 67 counties from the CountySent Table.
It's basically a ON/OFF switch. Any ideas?
