[AccessD] Text Box Control Source Problem

Chris,

Try 
=Sum([qryIG_Wed]![DBAdminEventTime])

HTH

Rusty

-----Original Message-----
From: Chris Enright [mailto:cclenright at yahoo.com]
Sent: Tuesday, November 28, 2006 9:41 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Text Box Control Source Problem


I am doing a small job on Access 2K and having strange happenings!
   
  I have a series of Text Boxes in the Form Footer which should add up
minutes spent by employees on different tasks. However they are all showing
#Error
   
  If I enter into the Control Source of one Text Box:    
   
  =Sum([qryIG_Wed].[DBAdminEventTime])
   
  and try to save it, it changes to 
   
  =Sum(qryIG_Wed.DBAdminEventTime)
   
  If I enter 
   
  =Sum(qryIG_Wed.DBAdminEventTime)
   
  and press Enter, it changes to
   
  =Sum([qryIG_Wed].[DBAdminEventTime])
   
  If I View the Form I have #Error, however if I have the Properties Box
open in View Mode and enter
   
  =Sum(qryIG_Wed.DBAdminEventTime)
   
  it converts it to
   
  =Sum([qryIG_Wed].[DBAdminEventTime])
   
  and the correct figure is shown in the Text Box.
   
  I have spent 4 hours on this problem and it is driving me crazy!  I have
tried importing everything into a new database. Compacted and repaired. In
fact everything I can think of short of using a hammer on the computer.
(within the next hour).
  I am sure I am missing something very easy.
   
  Someone help me please
   
  Chris

 
---------------------------------
Everyone is raving about the all-new Yahoo! Mail beta.
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

**********************************************************************
WARNING: All e-mail sent to and from this address will be received,
scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc.
corporate e-mail system and is subject to archival, monitoring or review 
by, and/or disclosure to, someone other than the recipient.
**********************************************************************