Thank you for accepting me. I'm not very experienced with Access. What I know, I taught myself, so please excuse my lack of knowledge.
I have a main form with a nested subform. In the 2nd subform, I have a cascading combo box. This is my Row Source in the 2nd combo box.
SELECT tblTreatments.TreatmentID, tblTreatments.[TypeID], tblTreatments.Treatment FROM tblTreatments WHERE (((tblTreatments.[TypeID])=Forms!frmPatient!frmMedicalSubform.form!frmMedicalTreatmentssubform.Form!cboTreatType));
When I open the form I get an error (see attachment)