Re: equation in form won't equal



I did break it a few lines down. I am now looking up the correct value in a
query using dlookup- though I read somewhere to stay away from dlookups...

"Michael J. Strickland" wrote:

> "Tammy F" <TammyF@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:126B9925-7881-46EB-9C0B-B120EE9970B9@xxxxxxxxxxxxxxxx
> >I have a button, that upon pushing is supposed to fill other fields in from
> > the subform....
> > 1. It worked at one point- and now it won't!
> > 2. is there a better way to do this?
> >
> > Forms!frm_request!Casefreight =
> > Forms!frm_request!Frm_Request_Items!sumcasefreight
> > When I break the code the Casefreight =0 and the sumcasefreight = 42.77.
> >
> > What is going on?
> >
>
>
> Not sure about your main problem but when you break the code on the above
> statement it breaks before the statement is executed so it is normal
> that the two values are not equal. Try breaking on the statement after the
> above statement and the two values should be equal.
>
>
>
> --
> ---------------------------------------------------------------
> Michael J. Strickland
> Quality Services qualityser@xxxxxxx
> 703-560-7380
> ---------------------------------------------------------------
>
>
>
.