Results 1 to 2 of 2
  1. #1
    rjk1080 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2009

    Question Form expression result doesn't show up in table

    Another novice question I'm afraid...

    I created a "Transactions" form that adds the data to the "transactions" table.

    The form has the following fields:

    Price per unit
    Number of units
    Total Purchase

    I created an expression for the "Total Purchase" field to make the result automatic after you type in the Price per unit and number of units. It works great in the form. However, the "total purchase" field of the table is blank. The expression result on the form is not rolling over to the table.

    Is there a way to fix this? Again, any help greatly appreciated.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    8300' in the Colorado Rocky Mountains
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Data won't show up in table field
    By texzen123 in forum Forms
    Replies: 3
    Last Post: 11-26-2009, 11:20 AM
  2. Show two tables in single table
    By access in forum Forms
    Replies: 8
    Last Post: 06-11-2009, 11:57 AM
  3. Replies: 9
    Last Post: 03-24-2009, 09:19 PM
  4. Replies: 0
    Last Post: 11-11-2008, 07:15 AM
  5. Query expression for form
    By pjacob in forum Forms
    Replies: 1
    Last Post: 10-10-2006, 09:12 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums