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...