[ms_access] Re: Continuous form problem

[tyki9799]

John, thanks for the response.

The form's record source is the following:

SELECT tblOfferDesigns.*, tblOffers.TaxRate
FROM tblOffers INNER JOIN tblOfferDesigns ON tblOffers.OfferID =
tblOfferDesigns.OfferID;

The unound textbox in question is txtOfferDesignUnitPrice.

The sub that makes the calculation is this:


Private Sub OfferDesignUnitPrice()

  Dim varX, varY

  varX = DSum("[ItemQuantity]*[ItemUnitPrice]*(1-[ItemDiscount])",
"tblOfferDesignDetails", "[OfferDesignID]=" & Me.[OfferDesignID])

  varY = CCur(Nz(varX * (1 + Me.TaxRate)))
  
  Me!txtOfferDesignUnitPrice = varY

End Sub


Then "OfferDesignUnitPrice" (i.e. the sub) is entered in the form's On
Current event procedure.

Thanks again,

Theodore


--- In ms_access@yahoogroups.com, "John Viescas" <[EMAIL PROTECTED]> wrote:
>
> Theodore-
> 
> If you can put a function call in the Record Source query that
includes in
> the parameters at least one field in the recordset, you should be
able to
> fix the problem.  What is the Control Source?  What is the code that
> calculates the value?  Are you requerying or refreshing from any
event in
> the form?
> 
> John Viescas, author
> "Building Microsoft Access Applications"
> "Microsoft Office Access 2003 Inside Out"
> "Running Microsoft Access 2000"
> "SQL Queries for Mere Mortals"
> http://www.viescas.com/
>  
> 
> -----Original Message-----
> From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED]
On Behalf
> Of tyki9799
> Sent: Wednesday, January 18, 2006 5:47 AM
> To: ms_access@yahoogroups.com
> Subject: [ms_access] Continuous form problem
> 
> Hi to all!
> 
> I have a continuous form with a calculated textbox. The calculation
> comes by some code in the form&#8217;s module. The trouble is that this
> textbox shows the same result for all form&#8217;s records. The
correct one
> is the one in the current record. I know this is common problem with
> continuous forms. What should I do so that the correct calculation
> shows for every record?
> 
> Thanks in advance
> 
> Theodore
> 
> 
> 
> 
> 
> 
>  
> Yahoo! Groups Links
>







 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/ms_access/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/