Cascading Combo box (1 Viewer)

Momma

Member
Local time
Today, 16:51
Joined
Jan 22, 2022
Messages
114
Untitled.jpg


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!
 

Attachments

  • 1642816883471.png
    1642816883471.png
    7.7 KB · Views: 256

Jon

Access World Site Owner
Staff member
Local time
Today, 05:51
Joined
Sep 28, 1999
Messages
7,305
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

Member
Local time
Today, 16:51
Joined
Jan 22, 2022
Messages
114
Sorry, I didn't mean to post it here. I'll repost!
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 22:51
Joined
Oct 29, 2018
Messages
21,358
Hi. Welcome to AWF!
 

Users who are viewing this thread

Top Bottom