Professional Web Applications Themes

Form wont update to table - Microsoft Access

I created a database by designing my tables and then using the form wizard to produce my forms. However when I enter info. into the form, although it works great in the form, it will not post the information to the corresponding table. Example below. Form: Amount Owed: =[Feet]*.15 Change: =[Amount Paid]-[Amount Owed] These calculate fine and the form works great except that the info does not show up on the form. The fields are set to Currency, and not indexed. I entered the expressions above in the form design screen by selecting the box, right clicking, selecting properties and ...

  1. #1

    Default Form wont update to table

    I created a database by designing my tables and then
    using the form wizard to produce my forms. However when
    I enter info. into the form, although it works great in
    the form, it will not post the information to the
    corresponding table. Example below.
    Form:
    Amount Owed: =[Feet]*.15
    Change: =[Amount Paid]-[Amount Owed]
    These calculate fine and the form works great except that
    the info does not show up on the form.
    The fields are set to Currency, and not indexed. I
    entered the expressions above in the form design screen
    by selecting the box, right clicking, selecting
    properties and entering the info as listed above in the
    control source field. Please let me know what I am doing
    wrong!!! THANK YOU!!!
    Jwell Guest

  2. #2

    Default Form wont update to table

    Based on what you have written, you have created two
    unbound fields. An unbound field is a field that is not
    tied to a field in the table. By changing the record
    source to an expression you created an unbound field.

    My suggestion would be to change the record source of both
    fields to the field name in the table and then write a
    small piece of code in the afterupdate event of the form.

    [Amount Owed] = [Feet]*.15
    Change =[Amount Paid]-[Amount Owed]

    Hope this helps.


     
    Ashby Guest

  3. #3

    Default Re: Form wont update to table

    You are not using Access properly if you do this.
    As long as you have the [Feet] field storing the number of feet (sold?),
    that (and the cost) is all you ever need to compute the AmountOwed and the
    Change.
    There is no reason to save it. When you do need that computation, in a form,
    query, or report, compute it, just as you already have.
    Same thing with 'Change'.
    That should not be a field in your table.
    When you must compute the change then,
    in an UNBOUND control:
    = [Amount Paid] - ([Feet]*.15)

    The only field you need, of all of these, is [Feet].
    Note: You should also have a field (in a different table) that stores the
    ..15 cost, in which case you would use, to determine the change:
    =[Amount Paid] - ([Feet] * DLookUp("[Cost]","CostTableName"))
    This way, all you need do when the cost changes, is update one field in the
    table, not all the code.
    --
    Fred

    Please reply only to this newsgroup.
    I do not reply to personal e-mail.


    "Jwell" <edu> wrote in message
    news:024301c35df3$53d5c320$gbl... 


    Fredg Guest

Similar Threads

  1. 4.0.3 - Images now wont retain their size after update
    By Haydn_Clark@adobeforums.com in forum Adobe Indesign Macintosh
    Replies: 2
    Last Post: July 6th, 08:59 AM
  2. Update a table without using a form
    By Wrapper Guy in forum Coldfusion Database Access
    Replies: 3
    Last Post: February 8th, 12:01 AM
  3. Replies: 0
    Last Post: August 20th, 02:46 PM
  4. Dreamweaver mx template wont update pages.
    By thebigx webforumsuser@macromedia.com in forum Macromedia Dreamweaver
    Replies: 6
    Last Post: July 22nd, 11:05 PM
  5. UPDATE MULTIPLE ROWS IN ONE TABLE OBTAINING SUMS FROM ANOTHER TABLE
    By Jon Spartan in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: July 9th, 04:48 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139