Cascading Combos in SubForm error

[Rohn Everson]

Our Customer Service team wants to track incoming field response
calls/requests. So, I have a simple form/subform but I am at an impasse as
to how to get the subforms cascading combos to work in the main form. They
worked great in the subform prior to placing it in the main form. Is this a
limit of Access or do I need to design the combos differently in a subform
situation?

The problem - I get a prompt to "enter the parameter value" but it should be
getting the parameter from the previous combobox!

SQL2000 back end and Access2003 front end database not ADP yet. Below is
the table structure:

FRDF_CONTACT (table)
ROW_ID - autonumber
DEFINITION - text
UNIT_ID - text
PROBLEM_DATE - date/time
REP - sql select from a view
ORIGINATOR - sql select from a view
DEALER - sql select from a view based on UNIT_ID
END_USER - sql select from a view based on UNIT_ID
COMPLETION_DATE - sql select from a view based on UNIT_ID
RECORD_CREATE_DATE - date/time
bla bla bla - other related data

FRDF_DETAILS (table)
ROW_ID - autonumber
DEFINITION - text
CONTACT_ROW_ID - number (mainform subform link)
DETAIL_COMMENTS - memo
bla bla bla - other unrelated fields
CATEGORY_A - memo
CATEGORY_B - memo
CATEGORY_C - memo
CATEGORY_D - memo
CATEGORY_E - memo
FRDF_COST - currency
bla bla bla - other unrelated fields

FRDF_INCIDENT (table)
ROW_ID - autonumber hidden on form
RECORD_ID - text, primary Key
CHILD_ID - text, child records of the RECORD_ID
CATEGORY - text, description of the incident

ACTION_TYPES (table)
DISPOSITION_TYPES (table)
REPORTS (table)
SYSUSERS (view)
EMPLOYEE (view)
PARTS (view)
VENDORS (view)
REPRESENTATIVES (view)

 

[Rohn Everson]

Maybe I am being dense here..... I tried most of the variable on the linked
document but none fit my scenario!

I don't have a control on the main form for these cascading combos. Within
the sub form I am selecting Category A and limiting the content of Category
B then based on B, I am limiting the content of Category C and ect.

My After Update event is:
Private Sub CATEGORY_B_AfterUpdate()

Me!CATEGORY_C = Null
Me!CATEGORY_C.Requery
Me!CATEGORY_D = Null

End Sub

Works as designed as a subform but when included in the main form the
cascading does not work. The codes in the link you posted still gives me
the same error. I tried different veriations for my queries, like:

Me!(F)FRDF_DETAIL.Form!CATEGORY_B
Forms!(F)FRDF_CONTACT!(F)FRDF_DETAIL.Form!CATEGORY_B
Me!(F)FRDF_DETAIL.Form.CATEGORY_B

 

[Rohn Everson]

MY BAD..... I found the solution thanks for the hints and tip sheet Allan!

See, I am dense most of the time, I used

[Forms]![(F)FRDF_CONTACT]![(F)FRDF_DETAILS]![CATEGORY_A]

Thanks, Rohn