• Updating a table field from form (Access 2000)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Updating a table field from form (Access 2000)

    Author
    Topic
    #412489

    Edited by HansV – huge amount of white space removed from attached picture. Please don’t post pictures larger than 640 by 480.

    I am trying to update a table field from a calculated control on a form. The form has a loan date and a returned date. I am calculating the difference in the ‘After Update’ event of the returned date control and receive the message in the attachment. The code is as follows: [daysout] = [returneddate] – [loandate]. Please advise. Thanks in advance.

    Viewing 1 reply thread
    Author
    Replies
    • #902562

      What is the Control Source of the DaysOut text box? It should be the DaysOut field from the table. If you have made it a calculated control, you can’t update it.

    • #902563

      What is the Control Source of the DaysOut text box? It should be the DaysOut field from the table. If you have made it a calculated control, you can’t update it.

    Viewing 1 reply thread
    Reply To: Updating a table field from form (Access 2000)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: