Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006

    Update Query

    I am very new to Access and learning by self. Somebody can help? Thank you in advance. Is it possible to use the data from a form in the "update To " in the grid?

    I have a table in which certain columns have to be update frequently. The data from the table is displayed in a form. It is infact a subform, which is in datasheetview. The user updates the fields he wants. Using the other fields as criteria,I want to update the particular field he changed in the original table. The field may have different data. Below is the SQL statements:

    UPDATE tblInventory SET tblInventory.Approved = Forms!frmImtMachCnc!frmReceivingAtMachCncPart1!frm ReceivingAtMachCncPart2!cmbApproved
    WHERE (((tblInventory.PartName)=Any (SELECT partname FROM tblReceivingAtMachCncCombine)));

    Since the 3rd form "frmReceivingAtMachCncPart2" is in datasheet view and there can be many rows and the field named "cmbApproved" can contain either "Yes" or "No".

    What happens when I run this code is that, the record in tblInventory which is same as the first record in form 'frmReceivingAtMachCncPart2" is update and rest of the records are not.

    Pls help. Thank you

  2. #2
    jobbie is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Apr 2014
    yes you can. you have to use: [Forms].[Textbox1]. etc to refer to the forms

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

Similar Threads

  1. update query question
    By blusk06 in forum Queries
    Replies: 3
    Last Post: 05-30-2008, 05:55 AM
  2. Update Query
    By GrnISSO in forum Queries
    Replies: 0
    Last Post: 06-15-2007, 05:41 PM
  3. Need help with an Update query ...
    By valkyry in forum Queries
    Replies: 0
    Last Post: 04-23-2007, 08:45 PM
  4. Need help with Update Query
    By starswinger007 in forum Queries
    Replies: 1
    Last Post: 02-22-2006, 08:44 PM
  5. Update Query
    By canadian1121 in forum Queries
    Replies: 1
    Last Post: 11-15-2005, 04:04 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