Another Subform requery problem

[Markvand]

Hi there,

I have a main form with combo:

SELECT TblProducts.ProductID, TblProducts.ProductName FROM TblProducts ORDER BY ProductName;

Subform is joined with main one with ProductID field. Subform is a continous one linked to a query:

SELECT TblBOM.ProductID, TblMaterials.MaterialID, TblMaterials.Name, TblMaterials.Vendor, TblMaterials.Producent, TblMaterialys.Group, TblMaterials.PE, IIf([price] Is Not Null,[price],[O_cu]+([Cu_Weight]*[DEL]/100)) AS Price2, TblMaterials.Curr, TAB_Materials.Menge, CCur(IIf([Price2] Is Null,"Price check",[Price2]*[exrate]/[PE])) AS PRISE, TblMaterials.date_start, TblMaterials.date_end
FROM tblFFDel, (TblCurr INNER JOIN TblMaterials ON TblCurr.Curr = TblMaterials.Curr) INNER JOIN TblBOM ON TblMaterials.MaterialID = TblBOM.MaterialID
WHERE (((TblBOM.ProductID)=[Forms]![FOR_Control]![Indeks]))
ORDER BY TblMaterials.MaterialID;

Now, what is bothering me. Query works fine, subform by itself works fine as well.
The problem is in the main form, in the combo I have After_Update event

me.subform.Requery, when I use a combo, I get compile error: "Method or Data Member" not found and me.subform.Requery is highlighted. I've checked the spelling and few other things with no result.

Some Help on this would be great.

Cheers,

Mark

 

[Ally]

Have you seen Mile-O's post on Main and subform syntax?This will probably answer your question. If not, post back.

 

[Markvand]

I've read it, and try it again, no luck this time either. Don't know what's going on here, I'm getting Run-Time Error: 2450

Help somebody

Mark