ComboBox2 dependent on ComboBox1

  • Thread starter Thread starter Don James
  • Start date Start date
D

Don James

I am probably making this way more difficult than it is but,

I have a table listing company data made up of CompID, name, address, etc
and a table listing contacts made up of ContactID, CompID, Fname & Lname and
a third table of call report data consisting of date, company, contact etc.

I want a call report form listing Date, Company (ComboBox1), Contact
(ComboBox2) and topics discussed. Basically I can make this work but the
Contact ComboBox lists ALL contacts in database. I would like it to list
only the contacts that work for the Company picked in ComboBox1. To make
matters worse I have virtually no fluency in SQL.
 
I just did one of these!

See Knowledge Base Article 209595 How to Synchronize Two
Combo Boxes on a Form
 
Back
Top