Cascaded Combo Boxes on a form?

[alfasprint]

Hello again.



I have a database with Patient Visits to my office and data collected in each visit.

The Frm_Ptn_VisitDate enters the Dates a Patient Visits my Office.

In the Frm_Testing I have a Form/Subform Configuration. If I select a Date in Combo17 (AptDate1 Label), it correctly changes the name of the Patient and the data collected in the specified date on the Subform.

1) What I can NOT do, is to have Combo17 show ONLY the dates a certain Patient visited my Office and not all the visits from all the Patients.

2) Another (better?) solution would be to create Cascaded Combo Boxes. For this cause I have added Combo19 from where you can select a Patient Name (I removed the duplicate values). Based on this Combo Box I would like Combo17 to show ONLY the dates this certain Patient visited my Office. Unfortunately I haven't succeeded so far.SO_FAR.zipSO_FAR.zip

Thanks for your help. Waiting for your feedback.

[orange]

You would have to have criteria for both Visit Date and Patient.
Without a constraint on Patient, you will get all patients
I don't use macros.

See this for cascading combo

[alfasprint]

Used simple way seen on
http://www.datapigtechnologies.com/f...combobox2.html

and it worked perfectly.

@orange: I try to figure out the difference of the dynamic and static update on your example.

[orange]

I usually send posters to the Datapig videos. This time, I suggested Baldyweb because others do.
I'll look at that site. Paul (Baldy) is an MVP and moderator here. It is his site and example I was pointing you to.

dynamic --he is using the value selected in state2, and actually modifying the rowsource of cbocities2

static --- he is using the value you selected in state1 in the sql to populate cbocities1