Results 1 to 5 of 5

Thread: Calculated field - Resolved

  1. Mar 4th, 2003, 08:34 AM #1
    CoderNewbie
    CoderNewbie is offline

    Thread Starter
    Addicted Member
    Join Date
    Apr 2002
    Location
    Anywhere but here
    Posts
    161

    Question Calculated field - Resolved

    Can someone point me in the right direction:

    I have a data1 control and its properly linked to a dbf file and the database is working great... but what im trying to do is have a calculated field. Something like:

    Total = Qty1 * Units

    Total is a textbox
    qty1 and units are textboxes as well linked to fields in the database.

    Now here's my problem... The calculated field updates when I hit next record but its calculated from the previous record

    Any help or direction will do.

    Thanks
    Last edited by CoderNewbie; Mar 4th, 2003 at 10:01 AM.
    -------------------------
    My name says it all!
    Reply With Quote Reply With Quote
  2. Mar 4th, 2003, 08:40 AM #2
    McGenius
    McGenius is offline
    Frenzied Member McGenius's Avatar
    Join Date
    Jan 2003
    Posts
    1,199
    You should use Change event for both (Qty and Units) textboxes to calculate totals.
    McGenius
    Reply With Quote Reply With Quote
  3. Mar 4th, 2003, 09:26 AM #3
    CoderNewbie
    CoderNewbie is offline

    Thread Starter
    Addicted Member
    Join Date
    Apr 2002
    Location
    Anywhere but here
    Posts
    161
    Hmmmm.... ok sounds like a plan. Let me look.

    Thanks
    -------------------------
    My name says it all!
    Reply With Quote Reply With Quote
  4. Mar 4th, 2003, 10:00 AM #4
    CoderNewbie
    CoderNewbie is offline

    Thread Starter
    Addicted Member
    Join Date
    Apr 2002
    Location
    Anywhere but here
    Posts
    161
    Hey that did it... simple yet right to the point.

    thanks man
    -------------------------
    My name says it all!
    Reply With Quote Reply With Quote
  6. Mar 4th, 2003, 10:20 AM #5
    McGenius
    McGenius is offline
    Frenzied Member McGenius's Avatar
    Join Date
    Jan 2003
    Posts
    1,199
    Sure, any time.
    McGenius
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width