Main/Subform relationship not working

[subx]

I've got a single table that I'd like to feed a form/subform with and have it controlled by a drop down box



1. Assets table showing asset details
2. Main form - This will have a combo box showing the main asset catagories
3. Subform - This will show the details of the assets

I have a combo box called Comb0 that has a catagory value

I have added the following VBA script:

Private Sub Combo0_AfterUpdate()

Assets.Form.Filter = "[Catagory]= '" & Combo0 & "'"

Assets.Form.FilterOn = True

End Sub

When I run the form and select a catagory in the drop down I get it leaves the subform blank without any values. I've attached a copy of the database in the following link:

https://drive.google.com/open?id=0B7...0VkVnB0bHhRYlU

Thanks,

[RuralGuy]

Why are you not using the LinkMaster/ChildFields properties of the Sub Form Control?