Sub-Sub Form Cascade Combo Boxes

[Huddle]

I have several problems but maybe if we fix one the others will fall in place. When I had the cascade combos in a subform it worked fine but when I moved it to a sub-subform I started having problems.



The first problem is when data is selected in the first combo box and you move to another field in the record the data is not saved or changed in the table. If you leave the record completely it saves it. What is causing this?

[cowboy]

For your specific problem you need to incorporate 1 of these, without seeing your code I dont know which one but this should get you started.

Forms("your form name").Refresh
Me.Refresh

Forms("your form name").Requery
Me.Requery

RunCommand acCmdSaveRecord

[Huddle]

OK I used the RunCommand and that worked but it didn't take care of the other issue like I was hoping.

I have a tab "Countermeasures"
with a Control whose Source Object is "SubForm_CM_Package"
in that is a SubForm "SubForm_Courtermeasures"
on that SubForm is a Control whose Source Object is "SubForm_CM_Details"
in that is a SubForm "Countermeasure Details"
on that SubForm we have the Cascade Combo "CmbSystem","CmbType", and "CmbElement"

In the Row Source of CmbType I have a SQL Q with Type and System fields and
[Forms]![Fm_Inventory]![SubForm_CM_Package].[Form]![CmbSystem]
as criteria for System.

It brings up a blank. I think I need to work in "SubForm_CM_Details" but I'm not sure of the syntax.

[Huddle]

I got it to work
[Forms]![Fm_Inventory]![SubForm_CM_Package].[Form]![SubForm_CM_Details].[Form]![CmbSystem]

I have to do the RunCommand on this field as well. Is this because it is a Sub Sub Form?

[cowboy]

The RunCommand acCmdSaveRecord saves the current record of the forms control source in which you are entering the code, so after you update a field it needs to save the information in order for it to relate to other parts of the project.

If your problem is fixed please mark the thread as solved.