Cascading combo on sub form

[james7705]

Good day
I have attached a sample of my database here.
the problem I am having is I have 2 combo boxes on my form which works perfectly. When I attach that form to another form as a subform, everything falls apart.
I have tried to create a subform in datasheet and it doesnt work.
I then tried to create a normal continuous form and attach it to my main form and it also doesnt work.
Everytime on my main form it does not populate the second combo box.


Please can someone help

[ranman256]

the query that looks at the combo must now use the path thru the subform,

if the 1st combo is STATES, then 2nd combo is CITY, the query for city must have the full path to the subform (use the builder, it always gets the path correct)

select [city] from tCityState where [state] = forms!myMasterForm!subForm!form!cboState

[ssanfu]

I would suggest you stop and step back a little.

You have spaces in every object name - you should remove every space.
Then read Autonumbers--What they are NOT and What They Are - under the NOT section, see #6
I would remove all of the Layouts on the forms.
You have fields names "Description" which is a reserved word (as is "Desc") and shouldn't be used for object names.


For the subforms, I don't understand why you are using a combo box for the description field...??