Cascading Combo box

[Momma]

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)
Please help!

 

[Jon]

Welcome to the forums! We are the most active Microsoft Access community on the internet by far, with posts going back over 20 years!

To get started, I highly recommend you read the post below. It contains important information for all new users to this forum.

https://www.access-programmers.co.uk/forums/threads/new-member-read-me-first.223250/

We look forward to having you around here, learning stuff and having fun!

 

[Momma]

Sorry, I didn't mean to post it here. I'll repost!

 

[theDBguy]

Hi. Welcome to AWF!