Lookup within a subform

[AXIAL]

Hi
Below is a SQL that i have added to a Access 2002 subform, problem is as soon as i access via a main form the lookup falls over. the main form is called FrmMaintenancePlan

SELECT MIC.Consequence, MIC.Conseq_Desc FROM TblMaintItemConseq AS MIC WHERE (((MIC.ConsequenceCatID)=[forms]![FrmMaintenancePlanItemsSubform]![Consequence Category]));



thanks for any tips

 

[John Big Booty]

This link should help you get the correct reference for your subform.