cascading combobox

[ashu.doc]

Hi
I am cascading comboboxes in a form which is actually a subform (B) in main form (A), when I am using the query

[forms]![B]![combobox]

its not working, do I have to make a query something like :



[forms]![A]![subforms]![B]![combobox]

I have tried this as well, but still cascading is not working.
Any suggestions?

[orange]

Can you describe exactly what you have? 2 combos on a subform?

What are the the row sources of the combos?

Have you seen the tutorials
http://www.datapigtechnologies.com/f...combobox1.html
http://www.datapigtechnologies.com/f...combobox2.html

form/subform syntax see http://access.mvps.org/access/forms/frm0031.htm

[ashu.doc]

Ok so I have a Main form called F_Alldetails in which there is a subform F_Patientdetails and there is a subform in patient details called F_SurgicalDetails. So in F_SurgicalDetails I have included 2 combo boxes one is called Speciality and other is Operations. There are few specialities and in each specialities there are many operations.
the row source for combo boxes is a table called Operations in which there are three fields - index, speciality and operations
Something is wrong in my syntax, I am using in the query :
[Forms]![F_Alldetails]![F_Patientdetails].[Form]![F_SurgicalDetails].[cmbspeciality]

not working in the main form, but when I am using subform F_SurgicalDetails separately :

[Forms]![F_SurgicalDetails].[cmbspeciality]

working fine

[orange]

Did you look at the link
form/subform syntax see http://access.mvps.org/access/forms/frm0031.htm
and try a few things?
Can you post a dumbed down copy of your mdb - remove confidential/personal stuff? Just enough records to show the issue with the forms/combos?

[ashu.doc]

Hi
I have tried from that site but as I said its not working, I am sending the database. If you can please look into F_Alldetails, there is a subform F_Patientdetails and subform to F_Patientdetails is F_SurgicalDetails. I have combo 18 & 20 in that form which I want to work on.

db1.zip

[orange]

Try changing the RowSource of cmboperation to

SELECT Operations.Operations FROM Operations WHERE (((Operations.Speciality)=[Forms]![F_Alldetails]![Patient details].[Form]![General Surgery].[Form]![cmbspeciality])) GROUP BY Operations.Operations;

[ashu.doc]

Try changing the RowSource of cmboperation to

SELECT Operations.Operations FROM Operations WHERE (((Operations.Speciality)=[Forms]![F_Alldetails]![Patient details].[Form]![General Surgery].[Form]![cmbspeciality])) GROUP BY Operations.Operations;

Great!! I think that is why people call you champ.

[orange]

Glad you have it working. I'll mark this thread Solved.