PC Review


Reply
Thread Tools Rate Thread

Urgent !!! - Values from Subform - #Error if no records in Subform and Only grabs first subform record

 
 
Greg
Guest
Posts: n/a
 
      17th Feb 2005
Please help!!

I have two subforms and need to get the value totals from one subform to the
other, based on multiple criteria.


The criteria to include the totals (SumOfConfirmed) into From A
(qry_Projection_subform) from Form B (qry_Buyin_Totals subform) are whenever
the Product_Code and Whse both match in each form. The Product_Code/Whse
combination only appears once in each form.

In Form A I have included a text box with the control source:

=IIf([Product_Code]=Forms!frm_Projection![qry_Buyin_Totals
subform].Form!Product_Code And [Whse]=Forms!frm_Projection![qry_Buyin_Totals
subform].Form!Whse,Forms!frm_Projection![qry_Buyin_Totals
subform].Form!SumOfConfirmed,0)


If there are no records (matching or not) in Form B, then I get the result
#ERROR.

If there are records, only if the record in Form A matches the first record
in Form B do I get the proper results ... otherwise 0 (zero) appears.

Any help you can provide would be greatly appreciated.

Greg



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
when add new records grabs persons name from Previous record babs Microsoft Access 1 16th Sep 2009 04:27 PM
Vista grabs first IP in routers range =?Utf-8?B?SmVycnkgTGFuZ2xleSBJSUk=?= Windows Vista Networking 4 19th Nov 2007 08:43 PM
Parameter Query grabs only Month and Year specifically =?Utf-8?B?TWFyYw==?= Microsoft Access 10 30th Aug 2006 10:12 PM
urgent urgent urgent urgent =?Utf-8?B?UGlldHJv?= Microsoft Access 2 11th Aug 2006 07:36 PM
AMD T-Bred 2400 and Lite-On CDRW up for grabs Ian News Editions 0 17th Jul 2003 05:33 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:28 AM.