Combo box query Search problem

[roccoau]

Hope someone can help me with this as I am not sure where I am going wrong.
I have two combo box's on a form which are linked to a query which when run SHOULD (this is my problem) populate a subform I have set up on same form.
If I run suborm or query on its own it works OK but I cannot get it to work from the main form.
I have attached sample of DB so you can see what I may be doing wrong.

Thanks for any help

Rgds

 

[Oldsoftboss]

The criteria:
[Forms]![frmCivilUpdate]![Txtsize]

should be in the SizeID column in your query, not the size column


Put:
Me.frmCivilStockUpdateSubform.Requery

in the AfterUpdate event of each combobox. This will refresh the data

Dave

 

[roccoau]

Dave,
How stupid of me. And I spent hours trying to figure it out.
And thanks for the requery tip.

Thanks again
Roc

 

[roccoau]

Dave,
How stupid of me. And I spent hours trying to figure it out.
And thanks for the requery tip.

Thanks again
Roc

 

[roccoau]

Dave,
How stupid of me. And I spent hours trying to figure it out.
And thanks for the requery tip.

Thanks again
Roc

 

[roccoau]

Sorry about multiple posts my computer is playing up.