Cascading Combo Boxes (VBA coding)

[vandy05]

Okay I need some help with cascading combo boxes. See below:

Master Site Table: Site ID (Investigational Site), Investigational Site, Mailing Address, Mailing Address 2,

Mailing Address 3,Mailing Address 4, Mailing Address 5, Mailing City, Mailing State, Mailing, Zip Code, Mailing Country, Shipping Address, Shipping Address 2, Shipping Address 3, Shipping Address 4, Shipping Address 5, Shipping City, Shipping State, Shipping Zip Code, Shipping Country​

​

Site Personnel Table: Personnel ID,Site ID, Personnel Name, Title,

Phone,Fax, Pager, Email Address, Active​

​

Project Table: Project ID, Site ID (Investigational Site), Detail ID (Protocol # and Product),

Budget, Study Start Date,Study Completion Date, Comments, Precision Site​

​

Phone Contact Report Table: Site ID (Investigational Site), Detail ID (Protocol # and Product), Personnel ID (Personnel Name, Principal Investigator and Phone),Employee ID (Employee Name), Date Contacted,RE, cc, Comments, Comments 2, Comments 3, Follow-Up​

I am trying to create the form for the phone contact table. I want to be able to use cascading combo boxes to help fill in the information listed in ( ).
But I have no experience in VBA. Can someone please help me get this working???
Thanks!!

 

[Uncle Gizmo]

>>>I am trying to create the form for the phone contact table<<<

I completed a series of video instructions recently, LINK which demonstrate how to convert contact information stored in table format into several tables providing more functionality. I realise it's not exactly what you were looking for, however I thought it might be of interest to you.

 

[vandy05]

For this table:
Project Table: Project ID, Site ID (Investigational Site), Detail ID (Protocol # and Product), Budget, Study Start Date,Study Completion Date, Comments, Precision Site

I need a form that has the following combo boxes :

Combo Boxes:
* Site ID - display Investigational Site, save Site ID
* Detail ID 1 - cascading from Site ID Combo box - display Protocol #, save Detail ID
* Detail ID 2 - cascading from Detail ID 1 Combo box - display product - save NOTHING
* Personnel ID 1 - cascading from Detail ID 2 - display Personnel Name - save Personnel ID
* Personnel ID 2 - cascading from Detail ID 2 - with a query looking for PI, Principal Investigator - save NOTHING
* Personnel ID 3 - cascading from Personnel ID 1 - display phone # - save NOTHING
* Employee ID - display employee names - NO CASCADING NEEDED - save Contacted By

So my question is:

1 - Is that possible?
2 - For the data that is not saved, how will it appear in a report that requires all fields to be printed?