Charlotte Foust
charlotte.foust at gmail.com
Sat Jan 17 21:39:53 CST 2015
You're going to have to share the code for us to be of any help. The before update event of the order record? In that case, it won't work because the record hasn't been saved yet. I can't tell from your description if the errors are in a form, a report, code, or what. Charlotte On Sat, Jan 17, 2015 at 7:14 PM, Bill Benson <bensonforums at gmail.com> wrote: > I am getting nearly work out with Access not behaving as I would expect - > and in this case, as Help tells me it should. I have a process which needs > to save an order record then create an invoice. The invoice will have > amounts for various types of fees calculated as either based on an amount > entered per bottle, or a flat amount; but if a field FeeTypeid is set to a > value such that looking up that feetypeid in the FeeType table yields a > feeType of 'N/A', I do not want the amount to be calculated (ie, should be > zero). > > This determination is to be made in the Beforeupdate event. > > However, upon saving the record, that event is not firing. I have verified > in the form property sheet that this event is set to fire. > > Any help out there? Arrrggghghhgg! > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >