Thread: #name? error
View Single Post
  #1  
Old May 13th, 2010, 06:09 PM posted to microsoft.public.access.forms
Steve Stad
external usenet poster
 
Posts: 89
Default #name? error

Whats wrong with this expression in text box on main form reading value of
field [SumOfEmp_Act_Prod_Hrs] in subform named 'qry_Emp_TotalHrsWorked
subform' - it is getting #name? error

=IIf([Forms]![qry_Emp_TotalHrsWorked
subform]![SumOfEmp_Act_Prod_Hrs]1920,"EMP HOURS ARE GREATER THAN 1920","Emp
Product Hours Less Than 1920")