Cascading Combo box (1 Viewer)

Momma

Member
Local time
Tomorrow, 07:57
Joined
Jan 22, 2022
Messages
70
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: 198

Jon

Access World Site Owner
Staff member
Local time
Today, 22:57
Joined
Sep 28, 1999
Messages
5,909
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
Tomorrow, 07:57
Joined
Jan 22, 2022
Messages
70
Sorry, I didn't mean to post it here. I'll repost!
 

theDBguy

I’m here to help
Staff member
Local time
Today, 14:57
Joined
Oct 29, 2018
Messages
18,990
Hi. Welcome to AWF!
 

Users who are viewing this thread

Top Bottom